COF-C02 Question #209: Real Exam Question with Answer & Explanation

The correct answer is B: The query consumes many compute resources every time it runs.. A materialized view is beneficial when the query consumes many compute resources every time it runs (B), and when the results of the query do not change often and are used frequently (E). This is because materialized views store pre-computed data, which can speed up query perform

Performance Management

Question

A materialized view should be created when which of the following occurs? (Choose two.)

Options

AThere is minimal cost associated with running the query.
BThe query consumes many compute resources every time it runs.
CThe base table gets updated frequently.
DThe query is highly optimized and does not consume many compute resources.
EThe results of the query do not change often and are used frequently.

Explanation

A materialized view is beneficial when the query consumes many compute resources every time it runs (B), and when the results of the query do not change often and are used frequently (E). This is because materialized views store pre-computed data, which can speed up query performance for workloads that are run frequently or are complex.

Topics

#Materialized Views#Performance Optimization#Query Performance#Cost Management

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice Browse All COF-C02 Questions