DP-700 Exam QuestionsBrowse all questions from this exam
Go to Exam

DP-700 Exam - Question 83

You are implementing a medallion architecture in a Fabric lakehouse.

You plan to create a dimension table that will contain the following columns:

• ID

• CustomerCode

• CustomerName

• CustomerAddress

• CustomerLocation

• ValidFrom

• ValidTo

You need to ensure that the table supports the analysis of historical sales data by customer location at the time of each sale.

Which type of slowly changing dimension (SCD) should you use?

Show Answer
Correct Answer:

Discussion

2 comments
Sign in to comment
5e89616Option: A
Apr 9, 2025

https://learn.microsoft.com/en-us/fabric/data-warehouse/dimensional-modeling-dimension-tables#manage-historical-change

13d2a97Option: A
Apr 20, 2025

In a Slowly Changing Dimension (SCD) Type 2, historical data is preserved by adding a new record each time an attribute (like CustomerLocation) changes. This makes it ideal when: You need to track historical changes over time You want to perform analysis as of the state at the time of the sale