When should a multi-cluster warehouse be used in auto-scaling mode?
A.
When it is unknown how much compute power is needed
B.
If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)
C.
If the runtime of the executed query is very slow
D.
When a large number of concurrent queries are run on the same warehouse
The Answer Is:
D
This question includes an explanation.
Explanation:
A multi-cluster warehouse should be used in auto-scaling mode when there is a need to handle a large number of concurrent queries. Auto-scaling allows Snowflake to automatically add or remove compute clusters to balance the load, ensuring that performance remains consistent during varying levels of demand
COF-C02 PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 65% Discount on All Products,
Use Coupon: "ac4s65"