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.
ALL ANSWERS ARE TRUE
When discussing Virtual Warehouses, there are several characteristics that we can identify as true:
Customers can change the size of the Warehouse after creation: After a virtual warehouse has been created, customers are able to modify its size to scale compute resources up or down based on their current needs.
A Warehouse can be resized while running: It is possible to adjust the size of a virtual warehouse while it is running to accommodate changing workloads without needing to stop and restart the warehouse.
A Warehouse can be configured to suspend after a period of inactivity: To manage costs and resources efficiently, a virtual warehouse can be set up to automatically suspend after it has been inactive for a predefined period.
A Warehouse can be configured to auto-resume when new queries are submitted: This feature ensures that when new queries require processing, the warehouse can automatically resume operation without manual intervention.
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, 3 months agoMarge23
1 year, 7 months ago56d43d6
3 months, 4 weeks agoBobFar
1 year, 6 months agoTapasgup007
Highly Voted 2 years, 4 months agoPrakas1954
Most Recent 2 weeks, 3 days agojeny12138
2 weeks, 4 days agoSuryaG2490
1 month, 3 weeks agoMultiCloudIronMan
3 months, 1 week agodatarrr
3 months, 3 weeks agoA010199
4 months, 3 weeks agoShipra123
5 months, 1 week agoWydad_19
5 months, 3 weeks agom_sflk
5 months, 3 weeks agoaba2s
5 months, 3 weeks agomandar_007
6 months, 2 weeks agoABRocks
8 months, 1 week agoVLMBL_94
8 months, 3 weeks agovivekmani2021
8 months, 3 weeks agoAnithec0der
9 months, 1 week ago