Warehouse sizes and scaling in Snowflake - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a warehouse with the smallest size.

Snowflake

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

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

AX-SMALL

BLARGE

CMEDIUM

DX-LARGE

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing a larger size than needed wastes resources.

Using incorrect size names causes errors.

The smallest warehouse size in Snowflake is X-SMALL. It uses the least compute resources.

2fill in blank

medium

Complete the code to set the warehouse to auto-scale between 1 and 3 clusters.

Snowflake

ALTER WAREHOUSE my_wh SET MIN_CLUSTER_COUNT = 1, MAX_CLUSTER_COUNT = [1];

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

A2

B10

C5

D3

Attempts:

3 left

💡 Hint

Common Mistakes

Setting max cluster count less than min cluster count.

Using values outside allowed range.

Setting MAX_CLUSTER_COUNT to 3 allows the warehouse to scale up to 3 clusters automatically.

3fill in blank

hard

Fix the error in the code to enable multi-cluster scaling.

Snowflake

ALTER WAREHOUSE my_wh SET SCALING_POLICY = '[1]';

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

ADYNAMIC

BSTANDARD

CMANUAL

DAUTOMATIC

Attempts:

3 left

💡 Hint

Common Mistakes

Using unsupported scaling policy names.

Confusing manual and automatic scaling options.

The correct value to enable multi-cluster scaling is STANDARD. Other values are invalid.

4fill in blank

hard

Fill both blanks to create a warehouse that auto-suspends after 5 minutes and resumes automatically.

Snowflake

CREATE WAREHOUSE my_wh WITH AUTO_SUSPEND = [1], AUTO_RESUME = [2];

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

A300

BTRUE

CFALSE

D600

Attempts:

3 left

💡 Hint

Common Mistakes

Using auto-suspend time in minutes instead of seconds.

Setting auto-resume to FALSE disables automatic resume.

Auto-suspend time is set in seconds, so 300 means 5 minutes. Auto-resume must be TRUE to resume automatically.

5fill in blank

hard

Fill all three blanks to create a warehouse with size LARGE, max 4 clusters, and auto-suspend after 10 minutes.

Snowflake

CREATE WAREHOUSE my_wh WITH WAREHOUSE_SIZE = '[1]', MAX_CLUSTER_COUNT = [2], AUTO_SUSPEND = [3];

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

AMEDIUM

B4

C600

DLARGE

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing warehouse sizes.

Using auto-suspend time in minutes instead of seconds.

The warehouse size is LARGE, max clusters set to 4, and auto-suspend time is 600 seconds (10 minutes).