Question 78

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 (SCD) 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. Which three columns should you add? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

• A[EffectiveStartDate] [datetime] NOT NULL
• B[EffectiveEndDate] [datetime] NOT NULL
• C[OriginalProductDescription] NVARCHAR(2000) NOT NULL
• D[IsCurrentRow] [bit] NOT NULL
• E[OriginalColor] NVARCHAR(50) NOT NULL
• F[OriginalProductName] NVARCHAR(100) NULL