LeetQuiz Logo
About•Privacy Policy•contact@leetquiz.com
RedditX
© 2025 LeetQuiz All rights reserved.
Microsoft Azure Data Engineer Associate - DP-203

Microsoft Azure Data Engineer Associate - DP-203

Get started today

Ultimate access to all questions.


Comments

Loading comments...

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.

Exam-Like
Quiz related visual




Powered ByGPT-5