IBM
P2090-050 · Question #27
Using a date column as a distribution key may distribute rows evenly across dataslices, why is this a poor choice of a distribution key?
The correct answer is B. Queries on date range may involve processing skew. See the full explanation below for the reasoning.
Question
Using a date column as a distribution key may distribute rows evenly across dataslices, why is this a poor choice of a distribution key?
Options
- AQueries on the table will invoke compression.
- BQueries on date range may involve processing skew.
- CQueries on date range will utilize only host processing.
- DQueries on the table will invoke compression on the date columns.
How the community answered
(25 responses)- A16% (4)
- B72% (18)
- C8% (2)
- D4% (1)
Community Discussion
No community discussion yet for this question.