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

Question

Peter Unterasinger · Accepted Answer

The query consumes many compute resources every time it runs.

Peter Unterasinger · Accepted Answer

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

Peter Unterasinger · Answer

There is minimal cost associated with running the query.

Peter Unterasinger · Answer

The base table gets updated frequently.

Peter Unterasinger · Answer

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

List of questions