DP-300 Certification Practice Question #12

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?

Accepted Answer

In an Azure Synapse Analytics dedicated SQL pool, a date dimension table is relatively small and frequently joined with multiple fact tables. Replicating the table (Option B) stores a full copy of it on every compute node. This eliminates the need to move or shuffle the dimension data across nodes during query execution, thereby minimizing data movement and optimizing performance.

More DP-300 practice questions