Answer-first summary for fast verification
Answer: The base tables do not change frequently.
The correct answer is A because materialized views are designed to store pre-computed results and are most beneficial when the underlying base tables do not change frequently. This allows the materialized view to provide faster query performance by avoiding repeated computation, as the results are persisted and only refreshed when needed. Option B is incorrect because frequent changes to view results would require frequent refreshes, reducing the performance benefits. Option C is incorrect because materialized views are suitable for resource-intensive queries by caching results. Option D is incorrect because materialized views are ideal for frequently accessed query results to improve performance.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What are the reasons a Snowflake user would choose to use a materialized view over a standard view?
A
The base tables do not change frequently.
B
The results of the view change often.
C
The query is not resource intensive.
D
The query results are not used frequently.
No comments yet.