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

만든이
인쇄
퍼가기

순위표

비주얼 스타일

옵션

템플릿 전환하기

자동 저장된 게임을 복구할까요?