Exam SnowPro Core topic 1 question 614 discussion

We don't have information about Snowflake edition. For Standard edition we don't have option with multi-cluster.

D. It is a query queuing due to load, not an concurrency issue.

It's queuing issue hence you dont need new warehouse but need additional clusters within same warehouse. And as queries are already in system hence can't move queries to new warehouse without killing and resubmitting.

correct

Correct

Both C & D are correct. C: If the running query load is high or there’s queuing, consider starting a separate warehouse and moving queued queries to that warehouse. D: 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.

https://docs.snowflake.com/en/user-guide/warehouses-load-monitoring Slow Query Performance When you notice that a query is running slowly, check whether an overloaded warehouse is causing the query to compete for resources or get queued: 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.

Correct -- D 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.