What will happen to the query?

You have a large warehouse with auto suspend configured for 10 minutes. You submitted a query and it is going to run for more than 10 minutes.

What will happen to the query?
A . The query will automatically cancelled after 10 minutes
B. The query will go on a hold state
C. The query will continue to run

View Answer

Answer: C

Explanation:

Please note the section highlighted in red. It will suspend itself only in case of inactivity

A warehouse can be set to automatically resume or suspend, based on activity:

By default, auto-suspend is enabled. Snowflake automatically suspends the warehouse if it is inactive for the specified period of time.

By default, auto-resume is enabled. Snowflake automatically resumes the warehouse when any statement that requires a warehouse is submitted and the warehouse is the current warehouse for the session.

These properties can be used to simplify and automate your monitoring and usage of warehouses to match your workload. Auto-suspend ensures that you do not leave a warehouse running (and consuming credits) when there are no incoming queries. Similarly, auto-resume ensures that the warehouse starts up again as soon as it is needed.