Answer: SUSPEND_IMMEDIATE

The question asks which resource monitor setting cancels all active queries in a virtual warehouse when a threshold is met. According to Snowflake documentation and the community discussion, SUSPEND_IMMEDIATE is the correct setting. SUSPEND_IMMEDIATE immediately terminates all active queries and suspends the warehouse when the threshold is reached, which directly matches the requirement. In contrast: NOTIFY only sends alerts without taking action; NOTIFY_USERS is not a valid resource monitor action; SUSPEND waits for active queries to complete before suspending the warehouse, which does not cancel active queries. The community discussion with 100% consensus and reference to Snowflake documentation confirms D as the correct answer.

Author: LeetQuiz Editorial Team