SnowPro Core Certification — Question 1143

Which resource monitor setting will cancel all active queries in a virtual warehouse when the threshold is met?

Answer options

• A. NOTIFY
• B. NOTIFY_USERS
• C. SUSPEND
• D. SUSPEND_IMMEDIATE

Correct answer: D

Explanation

The correct answer is D, SUSPEND_IMMEDIATE, because it immediately cancels all active queries when the threshold is exceeded. Options A and B, NOTIFY and NOTIFY_USERS, merely send alerts without affecting the running queries, while C, SUSPEND, only pauses the warehouse rather than terminating active queries.