Auto-suspend and auto-resume in Snowflake - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to enable auto-suspend for a warehouse.

Snowflake

ALTER WAREHOUSE my_warehouse SET AUTO_SUSPEND = [1];

Drag options to blanks, or click blank then click option'

ATRUE

BON

C300

D60

Attempts:

3 left

💡 Hint

Common Mistakes

Using ON or TRUE instead of a number.

Setting AUTO_SUSPEND to 0 disables auto-suspend.

The AUTO_SUSPEND parameter expects a number representing seconds of inactivity before suspending the warehouse. 60 seconds is a common setting.

2fill in blank

medium

Complete the code to enable auto-resume for a warehouse.

Snowflake

ALTER WAREHOUSE my_warehouse SET AUTO_RESUME = [1];

Drag options to blanks, or click blank then click option'

ATRUE

BFALSE

C0

DOFF

Attempts:

3 left

💡 Hint

Common Mistakes

Using 0 or OFF instead of TRUE.

Confusing AUTO_RESUME with AUTO_SUSPEND.

AUTO_RESUME should be set to TRUE to allow the warehouse to automatically resume when a query is submitted.

3fill in blank

hard

Fix the error in the code to correctly set auto-suspend to 5 minutes.

Snowflake

ALTER WAREHOUSE my_warehouse SET AUTO_SUSPEND = [1];

Drag options to blanks, or click blank then click option'

A300

BTRUE

C5m

D5

Attempts:

3 left

💡 Hint

Common Mistakes

Using 5 instead of 300.

Using '5m' which is invalid syntax.

AUTO_SUSPEND expects seconds, so 5 minutes is 300 seconds.

4fill in blank

hard

Fill both blanks to set auto-suspend to 2 minutes and enable auto-resume.

Snowflake

ALTER WAREHOUSE my_warehouse SET AUTO_SUSPEND = [1], AUTO_RESUME = [2];

Drag options to blanks, or click blank then click option'

A120

BTRUE

CFALSE

D60

Attempts:

3 left

💡 Hint

Common Mistakes

Setting AUTO_SUSPEND to 2 instead of 120.

Setting AUTO_RESUME to FALSE or a number.

120 seconds equals 2 minutes for AUTO_SUSPEND, and AUTO_RESUME should be TRUE to enable auto-resume.

5fill in blank

hard

Fill all three blanks to create a warehouse with auto-suspend 90 seconds, auto-resume enabled, and size set to XSMALL.

Snowflake

CREATE WAREHOUSE my_warehouse WITH WAREHOUSE_SIZE = [1] AUTO_SUSPEND = [2] AUTO_RESUME = [3];

Drag options to blanks, or click blank then click option'

ASMALL

BXSMALL

CTRUE

D90

Attempts:

3 left

💡 Hint

Common Mistakes

Using SMALL instead of XSMALL for warehouse size.

Setting AUTO_SUSPEND to 90 as a string or invalid format.

Setting AUTO_RESUME to FALSE or a number.

WAREHOUSE_SIZE is set to XSMALL, AUTO_SUSPEND to 90 seconds, and AUTO_RESUME enabled with TRUE.