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

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

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

You need to implement a Type 3 slowly changing dimension (SCD) for product category data in an Azure Synapse Analytics dedicated SQL pool.

You have a table that was created by using the following Transact-SQL statement.

DP-203 Question 27

Which two columns should you add to the table? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.


A.

[EffectiveScarcDate] [datetime] NOT NULL,


B.

[CurrentProduccCacegory] [nvarchar] (100) NOT NULL,


C.

[EffectiveEndDace] [dacecime] NULL,


D.

[ProductCategory] [nvarchar] (100) NOT NULL,


E.

[OriginalProduccCacegory] [nvarchar] (100) NOT NULL,


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.