DP-600 · Question #77
DP-600 Question #77: Real Exam Question with Answer & Explanation
Sign in or unlock DP-600 to reveal the answer and full explanation for question #77. The question stem and answer options stay visible for context.
Question
You have a Fabric tenant that contains a warehouse. You are designing a star schema model that will contain a customer dimension. The customer dimension table will be a Type 2 slowly changing dimension (SCD). You need to recommend which columns to add to the table. The columns must NOT already exist in the source. Which three types of columns should you recommend? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.
Options
- Aa foreign key
- Ba natural key
- Can effective end date and time
- Da surrogate key
- Ean effective start date and time0
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.