Câu 11: SnowPro Advanced Administrator ADA-C01

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.)

1. A. Use a task to increase the cluster size for the time period that the more complex queries are running and another task to reduce the size of the cluster once the complex queries complete.
2. B. Have the group running the complex monthly queries use a separate appropriately-sized warehouse to support their workload. — đáp án hiện tại
3. C. Increase the multi-cluster maximum to 20 or more clusters.
4. D. Examine the complex queries and determine if they can be made more efficient using clustering keys or materialized views. — đáp án hiện tại
5. E. Increase the minimum number of clusters started in the multi-cluster configuration to 5.