SnowPro Core Certification — Question 756

Why would a Snowflake user decide to use a materialized view instead of a regular view?

Answer options

• 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.

Correct answer: A

Explanation

A materialized view is beneficial when the base tables do not change frequently because it stores the query result physically, allowing for faster access. The other options are incorrect as they suggest conditions where a materialized view would not be advantageous, such as frequent changes in data or low usage of results, which do not justify the overhead of maintaining a materialized view.