SnowPro Core Certification — Question 1023
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 is C because it specifies that notifications are sent to account administrators and that warehouses are suspended only after current statements finish executing, which is a critical aspect of resource management. Answers A and B are incorrect as they erroneously broaden the notification scope to all users or only virtual warehouse users, while D incorrectly states that the warehouses are suspended immediately, canceling ongoing statements.