Data Warehouse Concepts, Design, and Data Integration

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…

12. Question 12 What is the minimum “Budget” value for the “All Regions” column across positions? This question relates to the assignment step to create an axis aggregation for the…

11. Question 11 Which of these “Positions” does not exist in the “Marketing & Communication” department? 1 point   Graphics   Analyst Relations   Writer   Administration

10. Question 10 How many non-empty cells does the “Executive Management” department have? 1 point   5   4   2   3

9. Question 9 What is the “Actual” value of “All positions” in “Professional Services” for “Central” region? 1 point   3,994,859.00   20,068,039.00   None of the other choices shown…

8. Question 8 What is the “Budget” value of “Payroll” in the “Finance” Department for all regions? 1 point   1,139,285.00   1,045,415.00   226,000.00   236,395.00   None of…