Microsoft
70-463 · Question #94
You are designing a data warehouse with two fact tables. The first table contains sales per month and the second table contains orders per day. Referential integrity must be enforced declaratively…
The correct answer is C. Create a time dimension that can join to both fact tables at their respective granularity. Verses-Surrogate-Key.htm
Design and implement a data warehouse
Question
You are designing a data warehouse with two fact tables. The first table contains sales per month and the second table contains orders per day. Referential integrity must be enforced declaratively. You need to design a solution that can join a single time dimension to both fact tables. What should you do?
Options
- ACreate a time mapping table.
- BChange the level of granularity in both fact tables to be the same.
- CCreate a time dimension that can join to both fact tables at their respective granularity.
- DMerge the fact tables.
How the community answered
(46 responses)- A13% (6)
- B24% (11)
- C57% (26)
- D7% (3)
Explanation
Verses-Surrogate-Key.htm
Topics
#time dimension#fact table granularity#referential integrity#dimension design
Community Discussion
No community discussion yet for this question.