dp-203 Practice Question 1943
Exam: dp-203
Domain: Design and implement data storage
Topic: Implement logical data structures
Difficulty: medium
In a Synapse Dedicated SQL Pool environment, you need to distribute a table with high cardinality across multiple nodes to ensure efficient query performance. Which distribution method should you use to achieve this goal?
Answer Options
A
Round Robin
B
Hash
C
Replicate
D
None of the above
Correct Answer
B: Hash
Explanation
Hash distribution is ideal for tables with high cardinality because it distributes rows based on a hash value of one or more columns, ensuring that the data is evenly spread across all nodes. Round Robin and Replicate distributions do not provide the same level of even distribution and may lead to skewed data placement, which can negatively impact query performance.