Answer-first summary for fast verification
Answer: 1 million
In Azure Synapse Analytics dedicated SQL pools, round-robin distribution evenly distributes rows across all distributions in a round-robin fashion. The system has 60 distributions by default in dedicated SQL pools. Given that: - The table contains approximately 60 million rows per month - The table is partitioned by month - Round-robin distribution is used For each monthly partition (60 million rows), the rows will be evenly distributed across all 60 distributions. Therefore, each distribution will contain approximately 1 million rows per partition (60 million ÷ 60 = 1 million). This distribution pattern ensures balanced data distribution across all compute nodes, which is optimal for parallel query processing in dedicated SQL pools. The clustered columnstore index further enhances query performance on this distributed data structure.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
You are designing a sales transactions table in an Azure Synapse Analytics dedicated SQL pool. The table will have a clustered columnstore index and use round-robin distribution. It will contain approximately 60 million rows per month and will be partitioned by month.
Approximately how many rows will be in each distribution for a single partition?
A
1 million
B
5 million
C
20 million
D
60 million