Data Warehouse Concepts, Design, and Data Integration

10. Question 10 The Supply-Driven Methodology emphasizes 1 point   the need for new operational databases.   the analysis of existing data sources.   a balance between demand (user requirements)…

3. Question 3 A constellation schema has 1 point   multiple fact tables typically sharing some dimension tables.   a single fact table and multiple levels of dimension tables.  …

2. Question 2 A star schema has 1 point   a single fact table and multiple levels of dimension tables.   multiple fact tables typically sharing some dimension tables.  …

9. Question 9 The Demand-Driven Methodology emphasizes 1 point   a balance between demand (user requirements) and supply (data sources) aspects.   the identification of data marts to capture intended…

8. Question 8 Non strict dimension-fact relationships can be resolved by one or more of the following solutions. 1 point   Connecting fact rows without a parent dimension row to…

4. Question 4 The level of historical integrity 1 point   involves updates to fact tables.   should always be unlimited history.   has three choices for no history (overwrite…

3. Question 3 A snowflake schema has 1 point   multiple fact tables typically sharing some dimension tables.   a single fact table in 1-M relationships with dimension tables.  …

1. Question 1 A typical example of a snapshopt fact table contains 1 point   Purchase amounts   Attendance event occurrence   Account balances   Room reservation event occurrence

9. Question 9 An incomplete dimension-fact relationship can be resolved by. 1 point   Adjusting fact or dimension tables for a fixed number of exceptions   Using M-N relationships to…

7. Question 7 To resolve an incomplete rollup problem, you should 1 point   connect parent values without at least one child value to a default or duplicate child value….