Answer-first summary for fast verification
Answer: The query consumes many compute resources every time it runs., The results of the query do not change often and are used frequently.
According to Snowflake documentation and the community consensus (with 100% agreement and multiple upvoted comments), materialized views should be created when: (B) The query consumes many compute resources every time it runs - because materialized views pre-compute results to avoid expensive computations on each query execution, and (E) The results of the query do not change often and are used frequently - because materialized views provide performance benefits when the underlying data is relatively static but the query results are accessed repeatedly. Option A is incorrect because minimal cost queries don't benefit from materialized views. Option C is incorrect because frequently updated base tables make materialized views inefficient due to constant refresh requirements. Option D is incorrect because highly optimized queries that don't consume many resources don't need the overhead of materialized views.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
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.