nerdexam
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)
  • A
    3% (1)
  • B
    72% (23)
  • C
    19% (6)
  • D
    6% (2)

Community Discussion

No community discussion yet for this question.

Full A2090-560 Practice