nerdexam
Snowflake

COF-C02 · Question #189

How would a user run a multi-cluster warehouse in maximized mode?

The correct answer is C. Set the minimum Clusters and maximum Clusters settings to the same value. To run a multi-cluster warehouse in maximized mode, a user should set the minimum and maximum number of clusters to the same value. This ensures that all clusters are available when the warehouse is started, providing maximum resources for query execution.

Performance Management

Question

How would a user run a multi-cluster warehouse in maximized mode?

Options

  • AConfigure the maximum clusters setting to "Maximum."
  • BTurn on the additional clusters manually after starting the warehouse.
  • CSet the minimum Clusters and maximum Clusters settings to the same value.
  • DSet the minimum clusters and maximum clusters settings to different values.

How the community answered

(30 responses)
  • A
    3% (1)
  • C
    93% (28)
  • D
    3% (1)

Explanation

To run a multi-cluster warehouse in maximized mode, a user should set the minimum and maximum number of clusters to the same value. This ensures that all clusters are available when the warehouse is started, providing maximum resources for query execution.

Topics

#Multi-cluster warehouses#Warehouse configuration#Maximized mode

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice