Microsoft Exam 70-463 Topic 6 Question 2 Discussion

Actual exam question for Microsoft's 70-463 exam

Question #: 2
Topic #: 6

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?

ACreate a junk dimension for the geography dimension.

BImplement change data capture.

CCreate a conformed dimension for the geography dimension.

DCreate three geography dimensions.

Show Suggested Answer

Suggested Answer: C

by Erick at May 06, 2022, 09:19 AM

Limited Time Offer

25%

Off

Get Premium 70-463 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!