SnowPro Core Certification — Question 315

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

Answer options

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

Correct answer: B, E

Explanation

A materialized view is beneficial when a query is resource-intensive, as indicated in option B, since it can reduce the load on the database by storing pre-computed results. Option E is also correct because a materialized view is ideal for results that do not change frequently, allowing for efficient data retrieval without repeated computation. Options A, C, and D do not justify the need for a materialized view.