SnowPro Core Certification — Question 584

There are 300 concurrent users on a production Snowflake account using a single cluster virtual warehouse. The queries are small, but the response time is very slow.

What is causing this to occur?

Answer options

• A. The warehouse is queuing the queries, increasing the overall query execution time.
• B. The warehouse parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS is set too low.
• C. The application is not using the latest native ODBC driver which is causing latency.
• D. The queries are not taking advantage of the data cache.

Correct answer: A

Explanation

The correct answer is A because when there are many concurrent users, the warehouse can only process a limited number of queries at once, causing queuing and increased execution times. Option B is incorrect as it pertains to the timeout setting, which does not directly relate to the slowness caused by queuing. Option C is not the cause since the driver version does not inherently affect the queuing issue, and option D is misleading; while data cache usage is important, the main problem here is the queuing of queries.