nerdexam
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)
  • A
    16% (4)
  • B
    72% (18)
  • C
    8% (2)
  • D
    4% (1)

Community Discussion

No community discussion yet for this question.

Full P2090-050 Practice