True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.
True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.
A Virtual Warehouse consumes Snowflake credits even when inactive. In Snowflake, a Virtual Warehouse continues to consume credits as long as it is running, regardless of whether it is actively processing queries or not. To stop consuming credits, the Virtual Warehouse must be suspended.
Warehouse is billed even if it is inactive unless suspended
Unless a warehouse is suspended, it consumes credits.
Inactive = suspended according to https://docs.snowflake.com/en/user-guide/warehouses-tasks#starting-or-resuming-a-warehouse "A suspended (i.e. inactive) warehouse can be resumed through the web interface or using SQL"
Yes, Suspend is not equal to Inactive Charges will keep incur till get suspended/off
Check this document: https://docs.snowflake.com/en/user-guide/warehouses-overview#auto-suspension-and-auto-resumption "By default, auto-suspend is enabled. Snowflake automatically suspends the warehouse if it is inactive for the specified period of time." At that point Snowflake makes clear distinction between "active/inactive" and "suspended". And considering this article: https://docs.snowflake.com/en/user-guide/cost-understanding-compute#virtual-warehouse-credit-usage The only conclusion is that the answer to the question is A - Virtual Warehouse consumes credits even if it's inactive, as long as it's not suspended manually or by the auto-suspend functionality.
WAREHOUSE IS BILLED UNLESS IT IS NOT SUSPENDED
Does not consumes
B. False
B.False,When it is inactive or suspended, it does not consume credits.
Snowflake charges only when the warehouse is running. No cost when it's inactive (no running for 'tot' period) or suspended
A is correct
is inactive=suspended?
These two are not the same. Check this article: https://docs.snowflake.com/en/user-guide/warehouses-overview#auto-suspension-and-auto-resumption "By default, auto-suspend is enabled. Snowflake automatically suspends the warehouse if it is inactive for the specified period of time."
B is correct
It is false statement When an object is created, its ownership is set to the currently active primary role.
Correct Answer B Warehouses are only billed for credit usage while running. When a warehouse is suspended, it does not use any credits.