When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of queries is always queuing in the warehouse.
According to recommended best practice, what should be done to reduce the queue volume? (Choose two.)
To reduce the queue volume in a warehouse with a high volume of queries, the optimal solutions are to use multi-clustered warehousing to scale out warehouse capacity, and migrate some queries to a new warehouse to distribute the load. Multi-clustering allows handling higher concurrency by adding additional clusters, and creating a new warehouse can offload some of the queued queries, thus reducing the queue volume.
This is per Snowflake documentation: 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.
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.
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.
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
It's AD. Scaling up(B) is needed only when Query performance is slow.
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
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.
source: 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:AB
A&B r correct
Correct
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
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
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
Answer should be A,B
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