
Ultimate access to all questions.
You are implementing a Type 3 slowly changing dimension (SCD) for product category data in an Azure Synapse Analytics dedicated SQL pool. You have a table created with the following Transact-SQL statement:
CREATE TABLE dbo.DimProduct(
ProductKey int NOT NULL,
ProductAlternateKey nvarchar(25) NULL,
EnglishProductName nvarchar(50) NOT NULL,
Category nvarchar(50) NOT NULL
)
CREATE TABLE dbo.DimProduct(
ProductKey int NOT NULL,
ProductAlternateKey nvarchar(25) NULL,
EnglishProductName nvarchar(50) NOT NULL,
Category nvarchar(50) NOT NULL
)
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,