DP-203 Certification Practice Question #51

Question

You need to implement a Type 3 slowly changing dimension (SCD) for product category data in an Azure Synapse Analytics dedicated SQL pool.
You have a table that was created by using the following Transact-SQL statement.

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.
A.

B.

C.

D.

E.

Accepted Answer

A Type 3 slowly changing dimension preserves limited history inside the same row by adding extra columns that hold the prior and/or alternate version of the tracked attribute. Microsoft Learn distinguishes this from Type 2, which uses new rows and effective-date ranges. The community mostly converges on B and E because those columns best represent the current-versus-original/previous value pattern expected for Type 3. The only real ambiguity is naming: one alternative pair appears conceptually similar, but B and E match the intended design most cleanly.

More DP-203 practice questions