Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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.
