Snowflake SnowPro Advanced Administrator ADA-C01 Question # 20 Topic 3 Discussion

Snowflake SnowPro Advanced Administrator ADA-C01 Question # 20 Topic 3 Discussion

ADA-C01 Exam Topic 3 Question 20 Discussion:
Question #: 20
Topic #: 3

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? (Select TWO).


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.


B.

Have the group running the complex monthly queries use a separate appropriately-sized warehouse to support their workload.


C.

Increase the multi-cluster maximum to 20 or more clusters.


D.

Examine the complex queries and determine if they can be made more efficient using clustering keys or materialized views.


E.

Increase the minimum number of clusters started in the multi-cluster configuration to 5.


Get Premium ADA-C01 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.