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?
- A. HASH
- B. REPLICATE Correct
- C. ROUND_ROBIN
Explanation
A replicated table keeps a full copy on each Compute node, so joining it to any fact table needs no data transfer between nodes. A date dimension suits this because it is small and changes rarely. Joining a round-robin table usually requires reshuffling rows between nodes, and a hash-distributed table avoids movement only when the fact table is distributed on the same column, which is not practical for every fact table.
