nerdexam
IBM

A2090-614 · Question #114

Which index(es) are created when a multidimensional clustering (MDC) table is defined with only one dimension?

The correct answer is C. One index that serves as both the dimension block index and the composite block index. See the full explanation below for the reasoning.

Question

Which index(es) are created when a multidimensional clustering (MDC) table is defined with only one dimension?

Options

  • AOne composite block index and one unique index.
  • BOne composite clustering index and one dimension block index.
  • COne index that serves as both the dimension block index and the composite block index.
  • DOne index that serves as both the dimension block index and the composite clustering index.

How the community answered

(29 responses)
  • A
    7% (2)
  • B
    3% (1)
  • C
    76% (22)
  • D
    14% (4)

Community Discussion

No community discussion yet for this question.

Full A2090-614 Practice