DP-600 · Question #77
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…
The correct answer is C. an effective end date and time D. a surrogate key E. an effective start date and time0. To create SCD type 2 one needs to add a surrogate key + start/end date beside the other technical attributes. https://learn.microsoft.com/en-us/training/modules/populate-slowly-changing-dimensions-azure- synapse-analytics-pipelines/3-choose-between-dimension-types
Question
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.
Options
- Aa foreign key
- Ba natural key
- Can effective end date and time
- Da surrogate key
- Ean effective start date and time0
How the community answered
(24 responses)- A13% (3)
- B4% (1)
- C83% (20)
Explanation
To create SCD type 2 one needs to add a surrogate key + start/end date beside the other technical attributes. https://learn.microsoft.com/en-us/training/modules/populate-slowly-changing-dimensions-azure- synapse-analytics-pipelines/3-choose-between-dimension-types
Topics
Community Discussion
No community discussion yet for this question.