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, which creates severe data skew - all rows distribute to just 2 SPUs instead of spreading evenly. Good distribution keys require high cardinality to ensure uniform data distribution across all available SPUs.

Keep practicing — related questions