Answer-first summary for fast verification
Answer: Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses after all statements being executed by the warehouses have completed.
The correct answer is C because it accurately describes the Notify & Suspend action for a resource monitor in Snowflake. According to Snowflake documentation and the community discussion, this action sends notifications to account administrators with notifications enabled and suspends assigned warehouses only after all currently executing statements have completed. This prevents data corruption or incomplete operations by allowing running queries to finish before suspension. Option A is incorrect because notifications go to administrators, not all users. Option B is wrong as it mentions virtual warehouse users and incorrect threshold conditions. Option D is incorrect because it suspends warehouses immediately, canceling running statements, which is not the behavior of Notify & Suspend.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What action does a resource monitor take when configured with the Notify and Suspend setting?
A
Send an alert notification to all account users who have notifications enabled.
B
Send an alert notification to all virtual warehouse users when thresholds over 100% have been met.
C
Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses after all statements being executed by the warehouses have completed.
D
Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses immediately, canceling any statements being executed by the warehouses.
No comments yet.