nerdexam
IBM

A2090-614 · Question #85

What must be done to convert a populated base table to a multidimensional clustering (MDC) table?

The correct answer is A. Export the data, create an MDC table, and then import or load the data into the MDC table. See the full explanation below for the reasoning.

Question

What must be done to convert a populated base table to a multidimensional clustering (MDC) table?

Options

  • AExport the data, create an MDC table, and then import or load the data into the MDC table.
  • BExecute the ALTER TABLE ... ORGANIZE BY DIMENSIONS statement to convert the table.
  • CCreate an MDC table and then move the data in the base table to the MDC table with the
  • DExport the data, execute the ALTER TABLE ... ORGANIZE BY DIMENSIONS statement to

How the community answered

(51 responses)
  • A
    78% (40)
  • B
    4% (2)
  • C
    12% (6)
  • D
    6% (3)

Community Discussion

No community discussion yet for this question.

Full A2090-614 Practice