If a query takes 20 minutes to run and the warehouse auto-suspends after 15 minutes, what happens?

• A. The query will be canceled after 15 minutes
• B. The query will stop until the warehouse resumes again
• C. The query will finish as expected
• D. The warehouse will suspend immediately after 15 minutes but resume automatically

Answer: (C)

The important idea here is that auto-suspend happens during idle time, not while work is actively being done. If a query is running, the warehouse stays active—the idle timer is reset by ongoing work. So even though the auto-suspend threshold is 15 minutes, it won’t trigger while that 20-minute query is executing. The query will run to completion, and only after it finishes will the warehouse become idle and suspend according to its idle timeout.

In short, long-running queries prevent auto-suspend; the query finishes as expected, and the warehouse will suspend afterward if there are no new queries.