nerdexam
IBM

P2090-050 · Question #105

Columns in a table may be zonemapped. How are those columns chosen?

The correct answer is A. They are automatically selected by the system. See the full explanation below for the reasoning.

Question

Columns in a table may be zonemapped. How are those columns chosen?

Options

  • AThey are automatically selected by the system.
  • BThey are based on the same columns as the table's distribution key.
  • CThey are added via the ALTER TABLE ADD INDEX(column_name) statement.
  • DThey are added via the ALTER TABLE ADD ZONEMAP(column_name) statement.

How the community answered

(58 responses)
  • A
    76% (44)
  • B
    3% (2)
  • C
    16% (9)
  • D
    5% (3)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full P2090-050 Practice