Exam DP-700 topic 2 question 29 discussion

Actual exam question from Microsoft's DP-700

Question #: 29
Topic #: 2

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?

A. Type 2
B. Type 0
C. Type 1
D. Type 3

Show Suggested Answer

Suggested Answer: A 🗳️

by 5e89616 at April 9, 2025, 1:14 p.m.

Comments

Submit Cancel

13d2a97

3 weeks, 6 days ago

Selected Answer: A

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

upvoted 2 times

...

5e89616

1 month, 1 week ago

Selected Answer: A

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

upvoted 3 times

...

Exam DP-700 All Questions

View all questions & answers for the DP-700 exam

Exam DP-700 topic 2 question 29 discussion

Comments

13d2a97

5e89616

SY0-701