DP-203 Certification Practice Question #12

Question

You have an Azure Synapse Analytics dedicated SQL pool that contains the users shown in the following table.

User1 executes a query on the database, and the query returns the results shown in the following exhibit.

User1 is the only user who has access to the unmasked data.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Hot Area:

Accepted Answer

This is the standard Synapse dedicated SQL pool star-schema pattern. Microsoft Learn guidance strongly favors replicating small dimension tables to avoid shuffle during joins and hash-distributing large fact tables on an appropriate join key to improve query efficiency. The suggested answer and community consensus match that pattern, so this combination is the strongest answer.

More DP-203 practice questions