Multiple choice technology

Each node receives every row, e.g. to create a lookup file. What type of partitioning is this?

  1. Same

  2. Entire

  3. Hash By Key

  4. DB2

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

Entire partitioning sends every row to every partition/node. This is used when all nodes need complete data, such as creating reference lookup files or when every row must be processed everywhere. Same keeps existing partitions, Hash distributes by key, DB2 uses database partitioning.