Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 110

True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.

    Correct Answer: A

    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.

Discussion
iamPhDOption: A

Warehouse is billed even if it is inactive unless suspended

SurbinOption: A

Unless a warehouse is suspended, it consumes credits.

MBratOption: B

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"

PrashantGupta1616Option: A

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

rogerek077Option: A

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.

sfdumpsOption: A

WAREHOUSE IS BILLED UNLESS IT IS NOT SUSPENDED

BagviOption: B

Does not consumes

EmiBOption: B

B. False

Mallikharjuna452Option: B

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

Stevec80Option: B

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

abhijit2683Option: A

A is correct

junaid2107

is inactive=suspended?

rogerek077

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."

Mayuri917233Option: B

B is correct

KarBiswaOption: B

It is false statement When an object is created, its ownership is set to the currently active primary role.

datamech001Option: B

Correct Answer B Warehouses are only billed for credit usage while running. When a warehouse is suspended, it does not use any credits.