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.
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.
ABCD
The following statements are true of Snowflake Virtual Warehouses:
A. Customers can change the size of the Warehouse after creation
B. A Warehouse can be resized while running
C. A Warehouse can be configured to suspend after a period of inactivity
D. A Warehouse can be configured to auto-resume when new queries are submitted
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 2 years, 11 months agoMarge23
1 year, 3 months agoBobFar
1 year, 2 months agoTapasgup007
Highly Voted 2 years agoA010199
Most Recent 2 weeks, 3 days agoShipra123
1 month, 1 week agoWydad_19
1 month, 2 weeks agom_sflk
1 month, 2 weeks agoaba2s
1 month, 3 weeks agomandar_007
2 months, 1 week agoABRocks
4 months, 1 week agoVLMBL_94
4 months, 2 weeks agovivekmani2021
4 months, 3 weeks agoAnithec0der
5 months agoMallikharjuna452
5 months, 1 week agopranalig
6 months, 1 week agoPrashantGupta1616
6 months, 2 weeks agoPrashantGupta1616
6 months, 2 weeks agoAkshay0039
4 months, 4 weeks agojerintom
6 months, 3 weeks ago