With default settings, how long will a query run on snowflake

With default settings, how long will a query run on snowflake
A . Snowflake will cancel the query if it runs more than 48 hours
B. Snowflake will cancel the query if it runs more than 24 hours
C. Snowflake will cancel the query if the warehouse runs out of memory
D. Snowflake will cancel the query if the warehouse runs out of memory and hard disk storage

View Answer

Answer: A

Explanation:

STATEMENT_TIMEOUT_IN_SECONDS

This parameter tells Snowflake how long can a SQL statement run before the system cancels it. The default value is 172800 seconds (48 hours)

This is both a session and object type parameter. As a session type, it can be applied to the account, a user or a session. As an object type, it can be applied to warehouses. If set at both levels, the lowest value is used.