SnowPro Core Certification — Question 1323

What is the impact of increasing the number of concurrent users on a Snowflake virtual warehouse?

Answer options

• A. Improved performance for small, simple queries
• B. Improved performance for large, complex queries
• C. Decreased performance for large, complex queries
• D. Decreased consumption of Snowflake credits

Correct answer: C

Explanation

Increasing the number of concurrent users can lead to resource contention, which diminishes the performance of large, complex queries due to limited compute resources. While small, simple queries may benefit from more users, complex queries are more likely to suffer from decreased performance. Additionally, the consumption of Snowflake credits may not decrease as a result of this increased load.