Answer-first summary for fast verification
Answer: The queries on that view will generate an error message.
According to Snowflake documentation and the community discussion with high upvotes, when a materialized view is suspended using ALTER MATERIALIZED VIEW <name> SUSPEND, queries on that view will generate an error message. This is because the materialized view is no longer being refreshed and cannot serve current data. Option B is incorrect because it won't return the last stored data - it errors instead. Option C is incorrect as Time Travel doesn't apply in this scenario. Option D is incorrect because it doesn't return data with a warning; it generates an error that prevents data retrieval entirely.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What happens when a Snowflake user suspends the refresh of a materialized view?
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.
No comments yet.