SnowPro Core Certification — Question 1205

When would creating and using a standard view be preferable to using a materialized view?

Answer options

• A. The underlying query of the view takes a lot of time to run.
• B. The underlying query of the view is resource-intensive.
• C. The underlying query of the view is run on large data sets.
• D. The view results change often.

Correct answer: D

Explanation

A standard view retrieves the latest data directly from the underlying tables, making it suitable when the view's results change often. Materialized views store the query results, which can become outdated and require refreshing, making them less ideal for frequently changing data. The other options focus on performance or resource usage, which are more relevant to materialized views.