Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
Under which of the following circumstances should a materialized view be created? (Choose two.)
A
There is minimal cost associated with running the query.
B
The query consumes many compute resources every time it runs.
C
The base table gets updated frequently.
D
The query is highly optimized and does not consume many compute resources.
E
The results of the query do not change often and are used frequently.
