Exam SnowPro Core topic 1 question 237 discussion

This is per Snowflake documentation: https://docs.snowflake.com/en/user-guide/warehouses-load-monitoring.html#slow-query-performance

consider starting a separate warehouse and moving queued queries to that warehouse.

You are trying to solve for concurrency, so either scale out or add new warehouses

Correct answer:AB

A&B r correct

Correct

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

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.

Tricky question as scaling up (B) could potentially also help. However, I think it's A/D because the question is about loading data and, thus, concurrency, not complex queries.

AB, not AD, the key word here is 'always' which indicates the action needed is for following computes but not necessarily current running queries. moving queued queries to new warehouse is temp solution. scale up and scale out is the permanent solution. https://docs.snowflake.com/en/user-guide/warehouses-load-monitoring.html#slow-query-performance

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

correct answer

AD for sure

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

AB: 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.

This is interesting. A,B,D all 3 are correct according to https://docs.snowflake.com/en/user-guide/warehouses-load-monitoring.html#slow-query-performance

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