Exam SnowPro Core topic 1 question 237 discussion

If the running query load is high or there’s queuing, consider - starting a separate warehouse and moving queued queries to that warehouse. - Alternatively, if you are using multi-cluster warehouses, you could change your multi-cluster settings to add additional clusters to handle higher concurrency going forward.

It's AD. Scaling up(B) is needed only when Query performance is slow.

source: https://docs.snowflake.com/en/user-guide/warehouses-load-monitoring.html#slow-query-performance

if queries execute faster, there will be lesser queries in the queue. moving to another virtual warehouse may be a temporary fix, but when it's a persistent problem then you should first scale out your virtual warehouse. If scaling out does not fully address the issue, you should consider scaling up as well

Hi @Tapasgup007 from: https://docs.snowflake.com/en/user-guide/warehouses-load-monitoring.html#slow-query-performance If the running query load is high or there’s queuing, consider starting a separate warehouse and moving queued queries to that warehouse. Alternatively, if you are using multi-cluster warehouses, you could change your multi-cluster settings to add additional clusters to handle higher concurrency going forward. To Increse the size of warehouse is the right answer if: If the running query load is low and query performance is slow, you could resize the warehouse to provide more compute resources. You would need to restart the query once all the new resources were fully provisioned to take advantage of the added resources But the question said that we have " high volume of queries". So the right answers are A,D