SnowPro Core Certification — Question 1137

Using which object-level parameters will help limit query processing and concurrency slowdowns? (Choose two.)

Answer options

• A. MULTI_STATEMENT_COUNT
• B. ENABLE_QUERY_ACCELERATION
• C. STATEMENT_TIMEOUT_IN_SECONDS
• D. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
• E. QUERY_ACCELERATION_MAX_SCALE_FACTOR

Correct answer: B, E

Explanation

The correct answers, B (ENABLE_QUERY_ACCELERATION) and E (QUERY_ACCELERATION_MAX_SCALE_FACTOR), are specifically designed to enhance query performance and manage concurrency issues. The other options, while related to query handling, do not directly influence the acceleration of queries or the scaling of query performance.