Additionally, multi-cluster warehouses support all the same properties and actions as single-cluster warehouses, including:
Specifying a warehouse size.
Resizing a warehouse at any time.
Auto-suspending a running warehouse due to inactivity; note that this does not apply to individual clusters, but rather the entire multi-cluster warehouse.
Auto-resuming a suspended warehouse when new queries are submitted.
Correct, you can configure auto suspend and auto resume:
https://docs.snowflake.com/en/user-guide/warehouses-considerations#automating-warehouse-suspension
AND you can resize a wh even when it is running: https://docs.snowflake.com/en/user-guide/warehouses-overview
All of the following statements are true of Virtual Warehouses in Snowflake:
A. Customers can change the size of the Warehouse after creation: You can resize a warehouse at any time to adjust the compute resources.
B. A Warehouse can be resized while running: Warehouses can be resized even while they are running to accommodate changing workloads.
C. A Warehouse can be configured to suspend after a period of inactivity: You can set a warehouse to automatically suspend after a specified period of inactivity to save costs.
D. A Warehouse can be configured to auto-resume when new queries are submitted: Warehouses can be configured to automatically resume when new queries are submitted, ensuring that compute resources are available when needed.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
ggww
Highly Voted 3 years, 7 months agoMarge23
1 year, 11 months ago56d43d6
7 months, 3 weeks agoBobFar
1 year, 10 months agoTapasgup007
Highly Voted 2 years, 8 months agomishrask06
Most Recent 4 days, 3 hours agof7dbe29
3 weeks agonizmo63
1 month, 1 week agoHagarTheHorrible
1 month, 3 weeks agoslushmush
2 months, 1 week agoVijaya15
3 months agoPrakas1954
4 months, 1 week agojeny12138
4 months, 1 week agoSuryaG2490
5 months, 3 weeks agoMultiCloudIronMan
7 months agodatarrr
7 months, 2 weeks agoA010199
8 months, 2 weeks agoShipra123
9 months agoWydad_19
9 months, 2 weeks agom_sflk
9 months, 2 weeks ago