Multiple choice technology databases

In NPS, boolean data types make good distribution keys

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Boolean data types have only 2 possible values (true/false), which creates severe data skew - all rows distribute to just 2 SPUs instead of spreading evenly across all available SPUs. Good distribution keys need high cardinality to ensure uniform data distribution.

Keep practicing — related questions