DP-203 Certification Practice Question #93

Question

You are designing the dimensions for a data warehouse in an Azure Synapse Analytics dedicated SQL pool.

You build a table by using the statement shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the exhibit.

NOTE: Each correct selection is worth one point.

Accepted Answer

The exhibit shows all the classic Type 2 SCD columns: an identity-based warehouse key, a stable source/business key, effective start and end dates, and a current-row indicator. That pattern preserves history by creating a new row for each change, which is Type 2 rather than Type 1 or Type 3. Because `SalesRepID` is an `IDENTITY` column generated in the dimension table while `RepSourceID` represents the upstream identifier, `SalesRepID` is the surrogate key.

More DP-203 practice questions