To run a Multi-Cluster Warehouse in auto-scale mode, a user would:
To run a Multi-Cluster Warehouse in auto-scale mode, a user would:
To run a Multi-Cluster Warehouse in auto-scale mode, you need to set the Minimum Clusters and Maximum Clusters settings to different values. This configuration allows the system to dynamically scale up or down the number of clusters based on the workload. If the demands increase, additional clusters are started up to the maximum limit. Conversely, as the workload decreases, the system will shut down clusters to minimize resource usage and costs.
If you set the minimum cluster count less than the maximum cluster count, then the warehouse runs in Auto-scale mode.
D is Correct
D is correct
D is correct
The answer is correct as per Auto-scale: This mode is enabled by specifying different values for maximum and minimum number of clusters. In this mode, Snowflake starts and stops clusters as needed to dynamically manage the load on the warehouse: As the number of concurrent user sessions and/or queries for the warehouse increases, and queries start to queue due to insufficient resources, Snowflake automatically starts additional clusters, up to the maximum number defined for the warehouse. Similarly, as the load on the warehouse decreases, Snowflake automatically shuts down clusters to reduce the number of running clusters and, correspondingly, the number of credits used by the warehouse. refer: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html