Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam DP-203 Topic 5 Question 62 Discussion

Actual exam question for Microsoft's DP-203 exam
Question #: 62
Topic #: 5
[All DP-203 Questions]

You are implementing a star schema in an Azure Synapse Analytics dedicated SQL pool.

You plan to create a table named DimProduct.

DimProduct must be a Type 3 slowly changing dimension (SCO) table that meets the following requirements:

* The values in two columns named ProductKey and ProductSourceID will remain the same.

* The values in three columns named ProductName, ProductDescription, and Color can change.

You need to add additional columns to complete the following table definition.







Show Suggested Answer Hide Answer
Suggested Answer: A, B, C


Artem Bohdan
1 years ago
For Type 3 you are not allowed to change the original values for ProductName, ProductDescription, and Color. The answer should be A, B, E, F
upvoted 1 times

Save Cancel