dp-203 Practice Question 1944
Exam: dp-203
Domain: Design and implement data storage
Topic: Implement logical data structures
Difficulty: medium
You are designing a database schema for a transactional system in Azure Synapse Dedicated SQL Pool. The system requires frequent updates and reads from a large fact table. To optimize read performance while minimizing write amplification, which distribution method would you recommend?
Answer Options
A
Hash
B
Round Robin
C
Replicate
D
None of the above
Correct Answer
B: Round Robin
Explanation
Round Robin distribution is suitable for scenarios where the data needs to be evenly distributed across nodes to balance read and write operations. It minimizes write amplification by spreading writes across all nodes, which is beneficial for systems with frequent updates. Hash and Replicate distributions might not provide the same level of balanced performance for read-heavy workloads.