Which distribution type should you recommend to minimize data movement?

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
C . ROUND ROBIN

Answer: B

Explanation:

A replicated table has a full copy of the table available on every Compute node. Queries run fast on replicated tables since joins on replicated tables don’t require data movement. Replication requires extra storage, though, and isn’t practical for large tables.

Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-overview

Latest DP-203 Dumps Valid Version with 116 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments