
Answer-first summary for fast verification
Answer: STATEMENT_TIMEOUT_IN_SECONDS, STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
The question asks for object-level parameters that control query processing and concurrency. According to Snowflake documentation and the community discussion consensus (DE has 70% support with the highest upvotes), STATEMENT_TIMEOUT_IN_SECONDS (D) controls how long a running query can execute before being canceled, directly managing query processing time. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS (E) controls how long a query can remain queued before being canceled, managing concurrency by preventing indefinite queuing. While MAX_CONCURRENCY_LEVEL (A) is mentioned in some comments for concurrency control, it is a warehouse-level parameter, not an object-level parameter, making it incorrect for this question. DATA_RETENTION_TIME_IN_DAYS (B) and MIN_DATA_RETENTION_TIME_IN_DAYS (C) relate to data retention policies, not query processing or concurrency.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which object-level parameters can be configured to manage query processing and concurrency? (Choose two).
A
MAX_CONCURRENCY_LEVEL
B
DATA_RETENTION_TIME_IN_DAYS
C
MIN_DATA_RETENTION_TIME_IN_DAYS
D
STATEMENT_TIMEOUT_IN_SECONDS
E
STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
No comments yet.