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…

Question

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.

• A
  79% (22)
• C
  7% (2)
• D
  4% (1)
• E
  11% (3)

Explanation

A multi-cluster warehouse is a virtual warehouse that consists of multiple clusters of compute resources that can scale up or down automatically to handle the concurrency and performance needs of the queries submitted to the warehouse. A multi-cluster warehouse has a minimum and maximum number of clusters that can be specified by the administrator. Option A is a possible solution to address the issues happening once a month, as it allows the administrator to 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. This way, the warehouse can have more resources available to handle the complex queries without reaching the maximum limit of 10 clusters, and then return to the normal cluster size to save costs. Option B is another possible solution to address the issues happening once a month, as it allows the administrator to have the group running the complex monthly queries use a separate appropriately-sized warehouse to support their workload. This way, the warehouse can isolate the complex queries from the standard workload and avoid queue time and resource contention.

No community discussion yet for this question.