ADA-C01 · Question #33
A Snowflake Administrator has a multi-cluster virtual warehouse and is using the Snowflake Business Critical edition. The minimum number of clusters is set to 2 and the maximum number of clusters is s
Sign in or unlock ADA-C01 to reveal the answer and full explanation for question #33. The question stem and answer options stay visible for context.
Question
A Snowflake Administrator has a multi-cluster virtual warehouse and is using the Snowflake Business Critical edition. The minimum number of clusters is set to 2 and the maximum number of clusters is set to 10. This configuration works well for the standard workload, rarely exceeding 5 running clusters. However, once a month the Administrator notes that there are a few complex long-running queries that are causing increased queue time and the warehouse reaches its maximum limit at 10 clusters. Which solutions will address the issues happening once a month? (Choose two.)
Options
- AUse a task to increase the cluster size for the time period that the more complex queries are
- BHave the group running the complex monthly queries use a separate appropriately-sized
- CIncrease the multi-cluster maximum to 20 or more clusters.
- DExamine the complex queries and determine if they can be made more efficient using clustering
- EIncrease the minimum number of clusters started in the multi-cluster configuration to 5.
Unlock ADA-C01 to see the answer
You've previewed enough free ADA-C01 questions. Unlock ADA-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.