SnowPro Core Certification — Question 1280

Which parameters can be used together to ensure that a virtual warehouse never has a backlog of queued SQL statements? (Choose two.)

Answer options

• A. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
• B. STATEMENT_TIMEOUT_IN_SECONDS
• C. DATA_RETENTION_TIME_IN_DAYS
• D. MAX_CONCURRENCY_LEVEL
• E. MAX_DATA_EXTENSION_TIME_IN_DAYS

Correct answer: A, D

Explanation

The correct answers, A and D, ensure that the warehouse can manage SQL statements effectively by limiting the time a statement can be queued and maximizing concurrency. Options B, C, and E do not directly address backlog issues; B pertains to the execution time of statements, while C and E relate to data retention and extension, respectively.