blog

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….

6. Question 6 To resolve an incomplete drill-down problem, you should 1 point   use a parent group.   connect parent values without at least one child value to a…

2. Question 2 Typical examples of factless fact tables contain 1 point   Account balances   Room reservation event occurrence   Attendance event occurrence   Inventory level   Purchase amounts

7. Question 7 How many dimension(s) is/are in the column axis? 1 point   0   2   3   4   1

6. Question 6 How many dimension(s) is/are in the row axis? 1 point   4   3   0   2   1

13. Question 13 What is the average “Actual” value across all positions in the “Executive Management” department in the “Eastern” region? This question corresponds to the assignment step to create…