DP-203 Certification Practice Question #214

Question

You are designing a date dimension table in an Azure Synapse Analytics dedicated SQL pool. The date dimension table will be used by all the fact tables.
Which distribution type should you recommend to minimize data movement during queries?

Accepted Answer

A date dimension is a classic small dimension table used by many fact tables. Microsoft Learn recommends replicating small dimension tables so each compute node has a local copy, eliminating the broadcast or shuffle that would otherwise occur during joins. That directly minimizes data movement during queries.

More DP-203 practice questions