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.
Unless a warehouse is suspended, it consumes credits.
Warehouse is billed even if it is inactive unless suspended
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"
B. False
Does not consumes
WAREHOUSE IS BILLED UNLESS IT IS NOT SUSPENDED
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.
Yes, Suspend is not equal to Inactive Charges will keep incur till get suspended/off
Correct Answer B Warehouses are only billed for credit usage while running. When a warehouse is suspended, it does not use any credits.
It is false statement When an object is created, its ownership is set to the currently active primary role.
B 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."
A is correct
Snowflake charges only when the warehouse is running. No cost when it's inactive (no running for 'tot' period) or suspended
B.False,When it is inactive or suspended, it does not consume credits.