Exam SnowPro Core topic 1 question 779 discussion

We don't have information about Snowflake edition hence multi-cluster options couldn't be available to us

A Scaling up is for improving speed of a single complex query. Scaling out is for solving concurrency issues (queueing of many queries) Resizing a warehouse generally improves query performance, particularly for larger, more complex queries. It can also help reduce the queuing that occurs if a warehouse does not have enough compute resources to process all the queries that are submitted concurrently. Note that warehouse resizing is not intended for handling concurrency issues; instead, use additional warehouses to handle the workload or use a multi-cluster warehouse (if this feature is available for your account). https://docs.snowflake.com/en/user-guide/warehouses-considerations

For query complexity Scale Up , for concurrency and query load tuning scale out

C correct - https://docs.snowflake.com/en/user-guide/warehouses-multicluster

A correct - https://dzone.com/articles/snowflake-performance-tuning-top-5-best-practices