IBM
A2090-560 · Question #125
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
(32 responses)- A3% (1)
- B72% (23)
- C19% (6)
- D6% (2)
Community Discussion
No community discussion yet for this question.