Microsoft Data Engineering on Microsoft Azure DP-203 Question # 22 Topic 3 Discussion

Microsoft Data Engineering on Microsoft Azure DP-203 Question # 22 Topic 3 Discussion

DP-203 Exam Topic 3 Question 22 Discussion:
Question #: 22
Topic #: 3

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 all the current and previous values in ProductColor.

• Retain only the current and the last values in ProductSize.

Which type of SCD should you implement for each column? To answer, drag the appropriate types to the correct columns.

DP-203 Question 22


Get Premium DP-203 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.