QuestionQ66

VerifiedImplement and manage semantic models

You have a Fabric tenant that contains a warehouse.

You are designing a star schema model that will contain a customer dimension. The customer dimension table will be a Type 2 slowly changing dimension (SCD).

You need to recommend which columns to add to the table. The columns must NOT already exist in the source.

Which three types of columns should you recommend? Each correct answer presents part of the solution.

NOTE: Each correct answer is worth one point.

Choose three
Explanation

Type 2 slowly changing dimensions require three new columns not in the source: a surrogate key (D) to uniquely identify each row version since the business key is duplicated, an effective start date (E) indicating when the row became valid, and an effective end date (C) indicating when it expired. Foreign keys and natural keys already exist in the source data, so these are not newly added columns. These three columns are mandatory for implementing Type 2 SCD logic.

Community Discussion

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