MicrosoftMicrosoft
DP-600 · Question #38
DP-600 Question #38: Real Exam Question with Answer & Explanation
Sign in or unlock DP-600 to reveal the answer and full explanation for question #38. The question stem and answer options stay visible for context.
Submitted by yasin.bd· Apr 18, 2026Plan, implement, and manage a solution for data analytics
Question
You need to create a data loading pattern for a Type 1 slowly changing dimension (SCD). Which two actions should you include in the process? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.
Options
- AUpdate rows when the non-key attributes have changed.
- BInsert new rows when the natural key exists in the dimension table, and the non-key attribute
- CUpdate the effective end date of rows when the non-key attribute values have changed.
- DInsert new records when the natural key is a new value in the table.
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.
Topics
#Slowly Changing Dimensions (SCD)#SCD Type 1#Data Loading#Dimension Modeling