SnowPro Core Certification — Question 730

What is the impact on queries that are being executed when a resource monitor set to the “Notify & Suspend” threshold level is exceeded?

Answer options

• A. All statements being executed are queued.
• B. All statements being executed are restarted.
• C. All statements being executed are cancelled.
• D. All statements being executed are completed.

Correct answer: D

Explanation

When the 'Notify & Suspend' threshold is exceeded, the currently executing queries are allowed to finish their operations, which is why option D is correct. Options A, B, and C incorrectly suggest that the queries are either queued, restarted, or cancelled, which does not happen in this scenario.