SnowPro Core Certification — Question 999

What will happen if a Snowflake user suspends the updates to a materialized view?

Answer options

• A. The queries on that view will generate an error message.
• B. The queries on that view will return the last stored data.
• C. The queries on that view will return the data using Time Travel.
• D. The queries on that view will return the data with a warning message.

Correct answer: A

Explanation

When updates to a materialized view are suspended, any queries made against that view will produce an error message, indicating that the view is not currently updatable. Options B, C, and D are incorrect because they imply that the view can still return data, which is not possible when updates are suspended.