Answer-first summary for fast verification
Answer: STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
The question asks which parameter controls the maximum time a query can remain in a warehouse's processing queue during contention. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS (B) specifically defines the timeout for queued statements waiting for warehouse resources, making it the correct choice. The community discussion strongly supports B with 70% consensus and multiple references to Snowflake documentation confirming its purpose. STATEMENT_TIMEOUT_IN_SECONDS (A) controls execution time after a query starts running, not queue time, which is why it's incorrect. MAX_CONCURRENCY_LEVEL (C) limits concurrent queries but doesn't control queue timeout. QUERY_TIMEOUT_IN_SECONDS (D) is not a standard Snowflake parameter.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which parameter controls the maximum amount of time a query can remain in a warehouse's processing queue before being terminated during periods of warehouse contention?
A
STATEMENT_TIMEOUT_IN_SECONDS
B
STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
C
MAX_CONCURRENCY_LEVEL
D
QUERY_TIMEOUT_IN_SECONDS
No comments yet.