DP-203 · Question #321
Drag and Drop Question You have a data warehouse. You need to implement a slowly changing dimension (SCD) named Product that will include three columns named ProductName, ProductColor, and ProductSize
The correct answer is ProductName: Type 0; Color: Type 2; Size: Type 3. Type 0 is correct for ProductName because it prevents any changes to the original value (the field is fixed/static forever, retaining only the original value). Type 2 is correct for ProductColor because it retains all historical values by creating a new row for each change, prese
Question
Drag and Drop Question You have a data warehouse. You need to implement a slowly changing dimension (SCD) named Product that will include three columns named ProductName, ProductColor, and ProductSize. The solution must meet the following requirements:
- Prevent changes to the values stored in ProductName.
- Retain only the current and the last values in ProductSize.
- Retain all the current and previous values in ProductColor.
Which type of SCD should you implement for each column? To answer, drag the appropriate types to the correct columns. Each type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Answer:
Answer Area
Drag items
Correct arrangement
- ProductName: Type 0
- Color: Type 2
- Size: Type 3
Explanation
Type 0 is correct for ProductName because it prevents any changes to the original value (the field is fixed/static forever, retaining only the original value). Type 2 is correct for ProductColor because it retains all historical values by creating a new row for each change, preserving the full history of current and all previous values. Type 3 is correct for ProductSize because it retains only the current and one previous value by using dedicated columns (e.g., CurrentSize and PreviousSize), which matches the requirement to keep only the current and last values.
Topics
Community Discussion
No community discussion yet for this question.