What is the impact of increasing the number of concurrent users on a Snowflake virtual warehouse?
What is the impact of increasing the number of concurrent users on a Snowflake virtual warehouse?
Increasing the number of concurrent users on a Snowflake virtual warehouse typically results in decreased performance for large, complex queries. This is because as more users run queries concurrently, the resources of the virtual warehouse are spread thinner, which impacts the performance of demanding queries.
C correct - https://docs.snowflake.com/en/user-guide/warehouses-multicluster#:~:text=As%20the%20number%20of%20concurrent%20user%20sessions%20and%2For,to%20the%20maximum%20number%20defined%20for%20the%20warehouse.
C correct. Multi-cluster warehouses are best utilized for scaling resources to improve concurrency for users/queries. https://docs.snowflake.com/en/user-guide/warehouses-multicluster#benefits-of-multi-cluster-warehouses