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?
A.
Create a conformed dimension for the geography dimension.
B.
Implement change tracking.
C.
Create a degenerate dimension for the geography dimension.
D.
Create a Type 2 slowly changing dimension for the geography dimension.
Explanation: