nerdexam
IBM

A2090-560 · Question #80

What are two considerations for usage of materialized views? (Choose two)

The correct answer is C. Materialized views may improve query performance. E. Materialized views are considered for usage by the Optimizer. See the full explanation below for the reasoning.

Question

What are two considerations for usage of materialized views? (Choose two)

Options

  • AMaterialized views are not supported.
  • BMaterialized views are logical entities.
  • CMaterialized views may improve query performance.
  • DMaterialized views are the same as database views.
  • EMaterialized views are considered for usage by the Optimizer.

How the community answered

(29 responses)
  • A
    3% (1)
  • B
    10% (3)
  • C
    83% (24)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full A2090-560 Practice