Ultimate access to all questions.
You are implementing a star schema in an Azure Synapse Analytics dedicated SQL pool. You plan to create a table named DimProduct that must be a Type 3 slowly changing dimension (SCD) table with the following requirements:
ProductKey
and ProductSourceID
columns will remain the same.ProductName
, ProductDescription
, and Color
columns can change.You need to add three columns to the table definition to complete the implementation.
Which three columns should you add? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.