DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric

By Microsoft · Question Mode

QuestionQ39

VerifiedIngest and transform data

You are implementing a medallion architecture in a Fabric lakehouse.

You plan to create a dimension table containing these columns:

  • ID
  • CustomerCode
  • CustomerName
  • CustomerAddress
  • CustomerLocation
  • ValidFrom
  • ValidTo

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

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

Explanation

A Type 2 SCD retains historical versions of each customer record when an attribute such as CustomerLocation changes. ValidFrom and ValidTo define the effective period for each version, allowing sales facts to be analyzed using the location that applied on the sale date.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!