DP-203 Certification Practice Question #63

Question

You have an Azure Synapse Analytics serverless SQL pool that contains a database named db1. The data model for db1 is 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 only defensible first merge is `DimGeography` into `DimCustomer`, because a star schema removes normalized dimension branches. The tricky second blank asks for the number of tables *once the model is converted to a star schema*, not merely after one join operation. That implies `ProductLine` must also be flattened into `Product`, which leaves four dimensions plus the fact table: five tables total. Because the prompt is ambiguous enough that some commenters count 6, confidence is lower than usual, but the higher-quality reasoning supports 5.

More DP-203 practice questions