DP-600 · Question #207
DP-600 Question #207: Real Exam Question with Answer & Explanation
Sign in or unlock DP-600 to reveal the answer and full explanation for question #207. The question stem and answer options stay visible for context.
Question
In the data warehouse for Adventure Works, the company should track changes in sales territories over time to ensure historical facts are associated with the correct territory. Which slow- changing dimension (SCD) type should be used to support the versioning of vendors and their associated areas, using a surrogate key to define the date range validity of each version and including columns?
Options
- AType 1 SCD
- BType 2 SCD
- CType 3 SCD
- DType 6 SCD
Unlock DP-600 to see the answer
You've previewed enough free DP-600 questions. Unlock DP-600 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.