Posted by: Pdfprep
Post Date: April 12, 2021
Topic 2, Mix Questions
You are designing a slowly changing dimension (SCD) for supplier data in an Azure Synapse Analytics dedicated SQL pool.
You plan to keep a record of changes to the available fields.
The supplier data contains the following columns.
Which three additional columns should you add to the data to create a Type 2 SCD? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
A . surrogate primary key
B . foreign key
C . effective start date
D . effective end date
E . last modified date
F . business key
Answer: A,C,D
Comments (2)
A, C, D
yes the answer should be A,C,D as its Type 2 SCD with start date and end date Option C&D, and the history of changes might force SupplierSystemID column to have the same value for more than one row and the same can be overcome by adding surrogate primary key Option A. Hence the the Options A, C, D should be the correct answer.