When is a multicluster warehouse in maximized mode?

• A. When the minimum number of clusters is set to the same number as the maximum number of clusters
• B. When the maximum number of clusters is greater than the minimum
• C. When the warehouse uses a single cluster
• D. When clustering is disabled

Answer: (A)

Understanding how multicluster warehouses scale is key. A multicluster warehouse uses a pool of clusters to handle concurrent queries. The minimum clusters are kept running, and as demand grows the system can start additional clusters up to the maximum. When the minimum and maximum numbers are the same, the pool size is fixed, so no extra clusters are started or stopped. This keeps that exact number of clusters always running, which is why this setup is described as the maximized mode. If the maximum were larger than the minimum, the warehouse could auto-scale between them, which isn’t maximized. Using a single cluster isn’t multicluster, and disabling clustering stops the multicluster behavior entirely.