Microsoft
70-463 · Question #74
70-463 Question #74: Real Exam Question with Answer & Explanation
Sign in or unlock 70-463 to reveal the answer and full explanation for question #74. The question stem and answer options stay visible for context.
Question
You are designing an enterprise star schema that will consolidate data from three independent data marts. One of the data marts is hosted on SQL Azure. Most of the dimensions have the same structure and content. However, the geography dimension is slightly different in each data mart. You need to design a consolidated dimensional structure that will be easy to maintain while ensuring that all dimensional data from the three original solutions is represented. What should you do?
Options
- ACreate a conformed dimension for the geography dimension.
- BImplement change tracking.
- CCreate a degenerate dimension for the geography dimension.
- DCreate a Type 2 slowly changing dimension for the geography dimension.
Unlock 70-463 to see the answer
You've previewed enough free 70-463 questions. Unlock 70-463 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.