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?
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?
A replicated table has a full copy of the table available on every Compute node. This distribution type minimizes data movement during queries because the data required for joins with the date dimension table is already available on every node. This approach is ideal for smaller tables like a date dimension table, as it ensures fast query performance without the overhead of data shuffling. While replication requires additional storage, the trade-off is acceptable for small dimension tables like this one, providing efficient and performant query execution.
correct B
HASH = Fact/2+Gb table REPLICATE = Dimensionn ROUND_ROBIN = Staging
REPLICATE
date dimension table is small so choose replicate
Replicate
correct