Multiple choice technology platforms and products

5) Component used to distribute the record evenly in each partition

  1. a. Partition by Key

  2. b. Partition by Round Robin

  3. c. Partition by Expression

  4. d. Partition by Range

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Partition by Round Robin distributes records evenly across partitions by cycling through partitions sequentially - first record to partition 1, second to partition 2, and so on, then back to partition 1. This ensures balanced distribution regardless of data characteristics. Key partitioning causes skew if keys aren't uniformly distributed, Expression partitioning depends on the expression logic, and Range partitioning creates ordered but potentially uneven partitions.