Answer-first summary for fast verification
Answer: The warehouse is queuing the queries, increasing the overall query execution time.
The most likely cause is option A: The warehouse is queuing the queries, increasing the overall query execution time. A single-cluster virtual warehouse has limited concurrency capacity (typically 8 queries per cluster). With 300 concurrent users, most queries will be queued waiting for available slots, causing significant delays despite the queries being small. While option D (not using data cache) could contribute to slower individual query execution, the primary bottleneck here is clearly the concurrency limitation. Option B is incorrect because a low STATEMENT_QUEUED_TIMEOUT_IN_SECONDS would cause queries to timeout rather than just slow execution. Option C is unrelated as ODBC driver issues would affect connectivity, not the fundamental concurrency problem described.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A virtual warehouse with a single cluster is being used by 300 concurrent users on a production Snowflake account. The queries are small, but the response time is very slow.
What is the most likely cause of this performance issue?
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.
No comments yet.