Question 107
DP-203 voucher + Udemy course (lifetime access) = ₹3,500 for Indian ID card holders.
Details →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. 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[EffectiveStartDate] [datetime] NOT NULL,
- B[CurrentProductCategory] [nvarchar] (100) NOT NULL,
- C[EffectiveEndDate] [datetime] NULL,
- D[ProductCategory] [nvarchar] (100) NOT NULL,
- E[OriginalProductCategory] [nvarchar] (100) NOT NULL,