
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.
