nerdexam
Snowflake

COF-C02 · Question #163

How should a virtual warehouse be configured if a user wants to ensure that additional multi- clusters are resumed with no delay?

The correct answer is A. Configure the warehouse to a size larger than generally required. To ensure that additional multi-clusters are resumed with no delay, a virtual warehouse should be configured to a size larger than generally required. This configuration allows for immediate availability of additional resources when needed, without waiting for new clusters to…

Performance Management

Question

How should a virtual warehouse be configured if a user wants to ensure that additional multi- clusters are resumed with no delay?

Options

  • AConfigure the warehouse to a size larger than generally required
  • BSet the minimum and maximum clusters to autoscale
  • CUse the standard warehouse scaling policy
  • DUse the economy warehouse scaling policy

How the community answered

(33 responses)
  • A
    82% (27)
  • B
    9% (3)
  • C
    3% (1)
  • D
    6% (2)

Explanation

To ensure that additional multi-clusters are resumed with no delay, a virtual warehouse should be configured to a size larger than generally required. This configuration allows for immediate availability of additional resources when needed, without waiting for new clusters to start up.

Topics

#Virtual Warehouse#Multi-cluster Warehouse#Performance Tuning#Scaling

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice