Multiple choice technology databases

In NPS, the max number of columns that can be used for a distribution key?

  1. 2

  2. 3

  3. 4

  4. 5

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

In Netezza Performance Server (NPS), a table can be distributed on up to 4 columns when using multi-column distribution. Distributing on more than 4 columns is not supported by the query planner and database engine.