SnowPro Core Certification — Question 739

Which object-level parameters can be set to help control query processing and concurrency? (Choose two).

Answer options

• 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

Correct answer: D, E

Explanation

The correct answers, D and E, are related to managing how long a statement can run and how long a statement can wait in the queue, which are essential for controlling query processing and concurrency. Options A, B, and C do not directly relate to query execution timing or concurrency management.