Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
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.
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.
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.
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 2 years, 3 months agoSteveKarr
Highly Voted 2 years, 1 month agoasorock
9 months, 2 weeks agoYokoSumiGaeshi
1 year, 2 months agoifmateus
8 months, 1 week agoAdolinKholin
10 months, 2 weeks agoChhatresh
Most Recent 2 weeks, 3 days agoAnireddySaikiranReddy
2 months ago_yyukta
2 months agoe_l_i_a_s
3 months agoavashish
3 months, 2 weeks agoSolutionA
6 months, 1 week agopistachio99
6 months, 3 weeks agoSolutionA
6 months, 1 week agoifmateus
8 months, 1 week agoPoornaChandraIn
9 months, 3 weeks agoVS3497
10 months, 2 weeks agomalexandersalazar
11 months, 2 weeks agoMayuri917233
11 months, 2 weeks agojonathanb21
1 year agoJuciifer
1 year agolocation75
1 year ago