Free Preparation Discussions
MENU
Microsoft Exam DP-300 Topic 5 Question 113 Discussion
Topic #: 5
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 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.
Incorrect Answers:
C: A round-robin distributed table distributes table rows evenly across all distributions. The assignment of rows to distributions is random. Unlike hash-distributed tables, rows with equal values are not guaranteed to be assigned to the same distribution.
As a result, the system sometimes needs to invoke a data movement operation to better organize your data before it can resolve a query.
Laquanda
1 months agoTabetha
1 months agoJosue
5 days agoSommer
14 days agoAlberta
15 days agoLashon
2 months agoCharlene
9 days agoMozell
11 days agoAntonio
1 months agoLillian
2 months agoJesusa
2 months agoDawne
23 hours agoAlecia
4 days agoRegenia
6 days agoSueann
2 months agoLorrie
2 months agoMike
1 months agoToi
2 months agoMargret
3 months agoSocorro
3 months ago