DP-203 · Question #77
You are designing a slowly changing dimension (SCD) for supplier data in an Azure Synapse Analytics dedicated SQL pool. You plan to keep a record of changes to the available fields. The supplier data
The correct answer is A. surrogate primary key C. effective start date D. effective end date. Effective start date: This column should be used to store the date on which a particular record becomes effective. This will allow you to track the history of changes to the data over time. Effective end date: This column should be used to store the date on which a particular rec
Question
You are designing a slowly changing dimension (SCD) for supplier data in an Azure Synapse Analytics dedicated SQL pool. You plan to keep a record of changes to the available fields. The supplier data contains the following columns. Which three additional columns should you add to the data to create a Type 2 SCD? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
Exhibit
Options
- Asurrogate primary key
- Bforeign key
- Ceffective start date
- Deffective end date
- Elast modified date
- Fbusiness key
How the community answered
(24 responses)- A75% (18)
- B4% (1)
- E4% (1)
- F17% (4)
Explanation
Effective start date: This column should be used to store the date on which a particular record becomes effective. This will allow you to track the history of changes to the data over time. Effective end date: This column should be used to store the date on which a particular record becomes no longer effective. This will allow you to track the history of changes to the data over time, and to easily identify the current valid record for each supplier. Surrogate primary key: This column should be used as a unique identifier for each record in the SCD. It can be used to join the SCD to other tables, and to ensure that there are no duplicate records in the SCD.
Topics
Community Discussion
No community discussion yet for this question.