Exam DP-203 topic 2 question 15 discussion

Correct answer

Why can't the name of the current ProductCategory be just "ProductCategory"? I would say that D and E could be also correct.

This is correct. The ProductCategory may represent a current product category or an original one, but we don't know. Wording on this question is a little off.

BE is Correct

Correct

To implement a Type 3 slowly changing dimension (SCD) for product category data in an Azure Synapse Analytics dedicated SQL pool and add the required columns to the existing table, you should add the following columns: A. [EffectiveStartDate] [datetime] NOT NULL, to track the start date of the current product category value. D. [ProductCategory] [nvarchar] (100) NOT NULL, to store the current product category value. Explanation: A Type 3 SCD tracks both the current and previous values of a column. For the product category data, you need to store the current product category value, as well as the previous/original value. To achieve this, you need to add the following columns to the existing table: A. [EffectiveStartDate] [datetime] NOT NULL, to track the start date of the current product category value. This column will store the date when the current product category value became effective. D. [ProductCategory] [nvarchar] (100) NOT NULL, to store the current product category value. This column will contain the most recent value for the product category.

BE is how you should answer, but in reality DE is better. The end user / analyst shouldn't have to remember "oh, this is a Type 3 SCD field so I need to look under 'C' for CurrentProductCategory instead of 'P' for ProductCategory."

Microsoft documentation is pretty confusing (https://learn.microsoft.com/en-us/training/modules/populate-slowly-changing-dimensions-azure-synapse-analytics-pipelines/3-choose-between-dimension-types) pictures have no sense. I find at this link a good explanation: https://medium.com/geekculture/6-different-types-of-slowly-changing-dimensions-and-how-to-apply-them-b152ef908d4e

This is the same question as Question #59Topic 1

Given Answer is correct !!

BE is correct

Right Answer!

the explanation is confusing as email is more likely to be a type2 change, it is also confusing as we need to add the "original" category (it should already be there as ProductCategory right?). So my first guess was only to add ProductCategory, but that would not be a scd change, only an initialization of a variable that could be subject to a scd-3 change. SO I guess the only viable option is adding "original" and "new" categories. I do not like scd3 type changes anyway, maybe there should be a special scd type2 historized scdtype3 dimension ? Okay, too much, lets stick with this answer BE (It says that the change is also metioning the Previous ProductCategory key wasn't there yet, but should have been)

BE is correct

Correct

correct

B and E