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

Question

Reneus Martini · Accepted Answer

The query consumes many compute resources every time it runs.

Reneus Martini · Accepted Answer

The results of the query do not change often and are used frequently.

Reneus Martini · Answer

There is minimal cost associated with running the query.

Reneus Martini · Answer

The base table gets updated frequently.

Reneus Martini · Answer

The query is highly optimized and does not consume many compute resources.

List of questions