Answer-first summary for fast verification
Answer: All statements being executed are completed.
The 'Notify & Suspend' action in Snowflake resource monitors allows currently executing queries to complete before suspending the warehouse. This is confirmed by the Snowflake documentation and community consensus, where all comments (with upvotes ranging from 1-3) unanimously select option D. The key distinction is that 'Notify & Suspend' completes running queries, while 'Notify & Suspend Immediately' would cancel them. Options A (queued), B (restarted), and C (cancelled) are incorrect as they do not align with the documented behavior of this specific threshold action.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What happens to currently running queries when a resource monitor reaches its "Notify & Suspend" action threshold?
A
All statements being executed are queued.
B
All statements being executed are restarted.
C
All statements being executed are cancelled.
D
All statements being executed are completed.
No comments yet.