70-463 · Question #130
70-463 Question #130: Real Exam Question with Answer & Explanation
The correct answer is C: Design a fact table with 10 dimensional key columns and 5 measure columns.. The requirements explicitly state: up to 10 dimension tables and up to 5 facts. A fact table's structure must reflect these cardinalities: it needs 10 dimensional key columns (foreign keys to each of the 10 dimension tables) and 5 measure columns (the 5 facts/metrics to aggregate
Question
Options
- ADesign a fact table with 5 dimensional key columns and 10 measure columns.
- BDesign a fact table with 5 dimensional key columns and 10 measure columns.
- CDesign a fact table with 10 dimensional key columns and 5 measure columns.
- DDesign a fact table with 10 dimensional key columns and 5 measure columns.
Explanation
The requirements explicitly state: up to 10 dimension tables and up to 5 facts. A fact table's structure must reflect these cardinalities: it needs 10 dimensional key columns (foreign keys to each of the 10 dimension tables) and 5 measure columns (the 5 facts/metrics to aggregate). Reversing these numbers - 5 dimensional key columns and 10 measure columns - would mean only 5 dimensions could be joined, violating the requirement to support all 10 dimensions. Columnstore indexes perform best on wide tables with many rows, making this design well-suited for billions of rows and aggregate queries across multiple dimensions.
Community Discussion
No community discussion yet for this question.