A virtual warehouse initially suffers from poor performance as a result of queries from multiple concurrent processes that are queuing. Over time, the problem resolved.
What action can be taken to prevent this from happening again?
A virtual warehouse initially suffers from poor performance as a result of queries from multiple concurrent processes that are queuing. Over time, the problem resolved.
What action can be taken to prevent this from happening again?
To prevent queuing and performance issues caused by multiple concurrent processes, altering the multi-cluster settings to add additional clusters can efficiently manage the load. Multi-cluster warehouses are specifically designed to handle large numbers of concurrent users and queries, providing the necessary scalability and flexibility to adapt to varying workloads, thereby improving overall performance and avoiding query queuing.
Multi-cluster warehouses are designed specifically for handling queuing and performance issues related to large numbers of concurrent users and/or queries. In addition, multi-cluster warehouses can help automate this process if your number of users/queries tend to fluctuate. https://docs.snowflake.com/en/user-guide/warehouses-considerations#multi-cluster-warehouses-improve-concurrency
C is correct