A is the correct answer.
Ref: https://docs.snowflake.com/en/user-guide/warehouses-considerations.html
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).
The answer literally justifies why it's A.. Scaling up improves query performance and can reduce queing to process queries submitted concurrently. "Use additional warehouses to handle the workload". Everything related to workload is solved through Scaling Out (more VW) and not by increasing the size of the VW.
Answer is D.
As you mention warehouse resizing is not intended for handling concurrency issues(i.e handling more queries). The solution for A would be multi-clustering.
Acc to snowflake document "In general, you should try to match the size of the warehouse to the expected size and complexity of the queries to be processed by the warehouse"
D is correct answer
If queries processed by a warehouse are running slowly, you can always resize the warehouse to provision more compute resources. The additional resources do not impact any queries that are already running, but once they are fully provisioned they become available for use by any queries that are queued or newly submitted.
Resizing a warehouse to a larger size is useful when the operations being performed by the warehouse will benefit from more compute resources, including:
Improving the performance of large, complex queries against large data sets.
Improving performance while loading and unloading significant amounts of data.
D is correct answer because when query is more complex then it will be using more compute power so in that case VW size should be increased from XS to medium
Should be D. If a query is too complex Snowflake would simply not be able to finished the query in XS warehouse. You have to increase to the warehouse size to medium to make it work.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
ggww
Highly Voted 3 years, 1 month agoSteveKarr
Highly Voted 2 years, 11 months agoasorock
1 year, 7 months agoYokoSumiGaeshi
2 years agoifmateus
1 year, 6 months agoAdolinKholin
1 year, 8 months agotharangaweer
Most Recent 3 weeks agomackel
5 months agoVLMBL_94
6 months, 3 weeks agoMallikharjuna452
7 months, 1 week agonsvsai1357
7 months, 2 weeks agopranalig
8 months, 1 week agop22_nilesh
8 months, 3 weeks agoJasMozai
9 months, 3 weeks agoChhatresh
10 months, 2 weeks agoAnireddySaikiranReddy
12 months ago_yyukta
1 year agoe_l_i_a_s
1 year, 1 month agoavashish
1 year, 1 month agoSolutionA
1 year, 4 months agopistachio99
1 year, 4 months agoSolutionA
1 year, 4 months ago