Why virtual warehouses control compute independently in Snowflake - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a virtual warehouse with a specific size.

Snowflake

CREATE WAREHOUSE my_warehouse WITH WAREHOUSE_SIZE = '[1]';

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

AEXTRA_LARGE

BMEDIUM

CLARGE

DSMALL

Attempts:

3 left

💡 Hint

Common Mistakes

Using an invalid warehouse size.

Leaving the size blank.

The warehouse size controls the compute resources allocated. SMALL is a valid size.

2fill in blank

medium

Complete the code to set the warehouse to auto-suspend after inactivity.

Snowflake

ALTER WAREHOUSE my_warehouse SET AUTO_SUSPEND = [1];

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

A300

BON

CNULL

D0

Attempts:

3 left

💡 Hint

Common Mistakes

Using ON instead of a number.

Setting 0 disables auto-suspend.

Setting AUTO_SUSPEND to 300 means the warehouse suspends after 300 seconds of inactivity.

3fill in blank

hard

Fix the error in the code to resume the warehouse.

Snowflake

RESUME WAREHOUSE [1];

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

Amy_warehouse

Bmywarehouse

Cmy-warehouse

Dmy warehouse

Attempts:

3 left

💡 Hint

Common Mistakes

Using spaces or dashes in warehouse names.

Misspelling the warehouse name.

Warehouse names cannot have spaces or dashes; underscores are valid.

4fill in blank

hard

Fill both blanks to create a warehouse that auto-resumes and has a specific size.

Snowflake

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

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

ATRUE

BFALSE

CMEDIUM

DLARGE

Attempts:

3 left

💡 Hint

Common Mistakes

Setting AUTO_RESUME to FALSE when auto-resume is needed.

Using invalid warehouse sizes.

AUTO_RESUME should be TRUE to enable automatic resume. MEDIUM is a valid warehouse size.

5fill in blank

hard

Fill all three blanks to alter a warehouse to suspend after 600 seconds, set size to LARGE, and enable auto-resume.

Snowflake

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

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

A300

B600

CLARGE

DTRUE

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong values for AUTO_SUSPEND or AUTO_RESUME.

Incorrect warehouse size spelling.

Setting AUTO_SUSPEND to 600 seconds, size to LARGE, and AUTO_RESUME to TRUE configures the warehouse properly.