1) What type of relationship does a foreign key establish between two tables in a relational database? a) One-to-One b) Many-to-Many c) One-to-Many d) None of the above 2) In a Star Schema, what is the primary purpose of the fact table? a) Store descriptive attributes b) Store quantitative data (measures) c) Establish relationships with other fact tables d) Normalize data 3) Which normalization form ensures that all non-prime attributes are fully functionally dependent on the primary key? a) First Normal Form (1NF) b) Second Normal Form (2NF) c) hird Normal Form (3NF) d) Boyce-Codd Normal Form (BCNF) 4) What is the purpose of a surrogate key in a data warehouse? a) Maintain data integrity b) Improve query performance c) Establish relationships between tables d) Identify the primary key 5) Which type of data warehouse schema involves multiple fact tables sharing dimension tables? a) Star Schema b) Snowflake Schema c) Galaxy Schema 6) What is the primary role of a dimension table in a data warehouse? a) Store quantitative data (measures) b) Store descriptive attributes c) Establish relationships with other dimensions d) Normalize data 7) In the context of data modeling, what does the acronym ERD stand for? a) Entity Relationship Diagram b) Extended Relational Database c) Entity Reference Data d) Enhanced Retrieval Design 8) What is the purpose of denormalization in a data warehouse? a) Improve data integrity b) Simplify data modeling c) Optimize query performance d) Ensure data consistency 9) What type of relationship is represented by a line connecting two entities in an Entity-Relationship Diagram (ERD)? a) Many-to-Many b) One-to-Many c) One-to-One d) All of the above

Data Model

door
Afdrukken
Embedden

Scorebord

Visuele stijl

Opties

Template wisselen

Automatisch opgeslagen activiteit "" herstellen?