SnowPro Core Certification — Question 213

During periods of warehouse contention, which parameter controls the maximum length of time a warehouse will hold a query for processing?

Answer options

• A. STATEMENT_TIMEOUT_IN_SECONDS
• B. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
• C. MAX_CONCURRENCY_LEVEL
• D. QUERY_TIMEOUT_IN_SECONDS

Correct answer: B

Explanation

The correct answer is B, STATEMENT_QUEUED_TIMEOUT_IN_SECONDS, as it specifically sets the time limit for how long a query can wait in the queue during high demand. The other options relate to different aspects of query execution and timeout settings, but they do not specifically govern the queuing duration under contention.