DP-203 Certification Practice Question #61

Question

You have an Azure subscription that contains an Azure Synapse Analytics dedicated SQL pool.
You plan to deploy a solution that will analyze sales data and include the following:

•	A table named Country that will contain 195 rows
•	A table named Sales that will contain 100 million rows
•	A query to identify total sales by country and customer from the past 30 days

You need to create the tables. The solution must maximize query performance.

How should you complete the script? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Accepted Answer

The `Sales` table is the large fact table, so Synapse guidance favors hash distribution on a high-cardinality join column such as `CustomerID`, especially for aggregations by country and customer. The `Country` table is tiny (195 rows), which is exactly the scenario where a replicated dimension eliminates data movement and maximizes join performance. Community comments line up cleanly with Microsoft guidance, and the repeated warning not to hash on dates matches Synapse distribution design guidance.

More DP-203 practice questions