IBM
P2090-050 · Question #84
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
(41 responses)- A5% (2)
- B10% (4)
- C83% (34)
- D2% (1)
Community Discussion
No community discussion yet for this question.