nerdexam
IBM

A2090-560 · Question #101

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

(40 responses)
  • A
    83% (33)
  • B
    5% (2)
  • C
    3% (1)
  • D
    10% (4)

Community Discussion

No community discussion yet for this question.

Full A2090-560 Practice