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

Question

CARL COUCH · Accepted Answer

The base table gets updated frequently.

CARL COUCH · Accepted Answer

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

CARL COUCH · Answer

There is minimal cost associated with running the query.

CARL COUCH · Answer

The query consumes many compute resources every time it runs.

CARL COUCH · Answer

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

List of questions