COF-R02 practice question 10 of 35
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?
Full set: 330 questionsCorrect Answer:
B. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
Explanation
The parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS sets the limit for a query to wait in the queue in order to get its chance of running on the warehouse. The query will quit after reaching this limit. By default, the value of this parameter is 0 which mean the queries will wait indefinitely in the waiting queue https://community.snowflake.com/s/article/Warehouse-Concurrency-and-Statement-TimeoutParameters#:~:text=The%20parameter%20STATEMENT_QUEUED_TIMEOUT_IN_SECONDS%20sets% 20the,indefinitely%20in%20the%20waiting%20queue.
Keep practicing
Take the free COF-R02 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other COF-R02 practice questions
- Question 1What is cached during a query on a virtual warehouse?
- Question 2Which command can be used to load data into an internal stage?
- Question 3Select the different types of Internal Stages: (Choose three.)
- Question 4If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a …
- Question 5Which of the following statements describes a benefit of Snowflake’s separation of comput…
- Question 6Which of the following objects can be cloned? (Choose four.)