QuestionQ77

Maintain a data analytics solution

You are implementing two dimension tables named Customers and Products in a Fabric warehouse.

You need to use slowly changing dimensions (SCDs) to manage data versioning. The solution must meet the requirements in the following table.

Question Image

Which SCD type should be used for each table? Each SCD type can be used once, more than once, or not at all.

Drag & Drop
Type 0
Type 1
Type 2
Type 3
Customers:
Products:
Explanation

SCD Type 2 preserves history by adding a new version when a dimension value changes, which meets the Customers requirement. SCD Type 1 overwrites the existing record and retains only the current value, which meets the Products requirement.

Learn more

Community Discussion

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