LeetQuiz Logo
Privacy Policy•contact@leetquiz.com
© 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 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:

  • The values in the ProductKey and ProductSourceID columns will remain the same.
  • The values in the 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.

Exam-Like
Quiz related visual





Powered ByGPT-5