What is the impact on queries that are being executed when a resource monitor set to the “Notify & Suspend” threshold level is exceeded?
What is the impact on queries that are being executed when a resource monitor set to the “Notify & Suspend” threshold level is exceeded?
When the 'Notify & Suspend' threshold level is exceeded, all statements being executed are completed before any action is taken. The process is such that after all currently executing statements are completed, the assigned warehouses are then suspended. This ensures that currently running queries finish their execution without abrupt termination.
D correct - Notify & Suspend Send a notification (to all account administrators with notifications enabled) and suspend all assigned warehouses after all statements being executed by the warehouse(s) have completed. Notify & Suspend Immediately Send a notification (to all account administrators with notifications enabled) and suspend all assigned warehouses immediately, which cancels any statements being executed by the warehouses at the time.
correct
Notify & Suspend Send a notification (to all account administrators with notifications enabled) and suspend all assigned warehouses after all statements being executed by the warehouse(s) have completed. Notify & Suspend Immediately Send a notification (to all account administrators with notifications enabled) and suspend all assigned warehouses immediately, which cancels any statements being executed by the warehouses at the time. Notify Perform no action, but send an alert notification (to all account administrators with notifications enabled).
D is correct Reference: https://docs.snowflake.com/en/user-guide/resource-monitors
Correct answer is D https://docs.snowflake.com/en/user-guide/resource-monitors Notify Notify&Suspend Notify and suspend immediately where the running queries are cancelled