DP-203 Certification Practice Question #28

Question

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.

Accepted Answer

Microsoft Learn guidance is consistent that large dedicated SQL pool tables used in production analytic joins should usually be hash-distributed on a good key. This reduces data movement and improves query performance compared with round-robin, while replication is reserved for much smaller tables. That makes hash distribution the best answer.

More DP-203 practice questions