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, 10 months agoMarge23
1 year, 2 months agoBobFar
1 year, 1 month agoTapasgup007
Highly Voted 1 year, 11 months agoShipra123
Most Recent 3 days agoWydad_19
1 week, 5 days agom_sflk
1 week, 5 days agoaba2s
2 weeks, 4 days agomandar_007
1 month, 1 week agoABRocks
3 months agoVLMBL_94
3 months, 2 weeks agovivekmani2021
3 months, 2 weeks agoAnithec0der
4 months agoMallikharjuna452
4 months agopranalig
5 months agoPrashantGupta1616
5 months, 1 week agoPrashantGupta1616
5 months, 2 weeks agoAkshay0039
3 months, 3 weeks agojerintom
5 months, 3 weeks agodeeshubh
6 months, 2 weeks ago