Exam SnowPro Core topic 1 question 407 discussion

Answer B STATEMENT_QUEUED_TIMEOUT_IN_SECONDS is a configuration parameter in Snowflake that specifies the maximum amount of time, in seconds, that a statement can remain in a queued state before timing out. STATEMENT_TIMEOUT_IN_SECONDS is a parameter in Snowflake that specifies the maximum amount of time that a query can execute before being automatically terminated by the system. The default value for this parameter is 0, which means there is no timeout limit set.

https://docs.snowflake.com/en/sql-reference/parameters.html#statement-queued-timeout-in-seconds

STATEMENT_QUEUED_TIMEOUT_IN_SECONDS Type Session and Object (for warehouses) Can be set for Account » User » Session; can also be set for individual warehouses Data Type Number Description Amount of time, in seconds, a SQL statement (query, DDL, DML, etc.) remains queued for a warehouse before it is canceled by the system.

B is correct

Hold for processing means queue, hold for running or cancelling means means A

https://docs.snowflake.com/en/sql-reference/parameters#statement-timeout-in-seconds

STATEMENT_QUEUED_TIMEOUT_IN_SECONDS Amount of time, in seconds, a SQL statement (query, DDL, DML, etc.) remains queued for a warehouse before it is canceled by the system. https://docs.snowflake.com/en/sql-reference/parameters#statement-queued-timeout-in-seconds

Verified

Verified

Amount of time, in seconds, a SQL statement (query, DDL, DML, etc.) remains queued for a warehouse before it is canceled by the system. This parameter can be used in conjunction with the MAX_CONCURRENCY_LEVEL parameter to ensure a warehouse is never backlogged https://docs.snowflake.com/en/sql-reference/parameters.html#statement-queued-timeout-in-seconds