SnowPro Core Recertification — Question 3
What does a Notify & Suspend action for a resource monitor do?
Answer options
- 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.
Correct answer: C
Explanation
The correct answer, C, accurately describes the behavior of the Notify & Suspend action by informing account administrators and allowing current processes to finish before suspending warehouses. Option A is incorrect as it does not specify the correct audience or context for notifications, B is wrong because it focuses on virtual warehouse users and specific thresholds, and D is incorrect as it suggests immediate suspension without waiting for ongoing statements to complete.