Exam SnowPro Core topic 1 question 110 discussion

Inactive - could mean idle but not suspended. This still consume credits.

False, As Inactive or suspended warehouse do not incur charges.

Suspend i.e inative

B.False,When it is inactive or suspended, it does not consume credits.

Yes, Suspend is not equal to Inactive Charges will keep incur till get suspended/off

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"

Snowflake charges only when the warehouse is running. No cost when it's inactive (no running for 'tot' period) or suspended

A is correct

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

is inactive=suspended?

Warehouse is billed even if it is inactive unless suspended

B is correct

Does not consumes

B. False

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.