Microsoft
70-463 · Question #189
70-463 Question #189: Real Exam Question with Answer & Explanation
Sign in or unlock 70-463 to reveal the answer and full explanation for question #189. The question stem and answer options stay visible for context.
Question
You are designing a data warehouse that contains a customer dimension. The customer dimension contains the original customer attributes as well as the most recent set of updated attributes. When a customer is updated, the original customer attributes must be preserved. The customer dimension design must: - Support a Type 3 Slowly Changing Dimension (SCD) process - Minimize the total storage consumed You need to design a solution that meets these requirements. What should you do?
Options
- ADesign two tables. One table will hold the original customer surrogate key and attributes.
- BDesign a table as a Type 2 SCD dimension that holds the surrogate key for each customer
- CDesign a table to hold the surrogate key for each customer and its attributes.
- DDesign a table to hold the surrogate key for each customer and its attributes as well as
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.