Multi-cluster warehouses in Snowflake - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a multi-cluster warehouse with auto-scaling enabled.

Snowflake

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

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

AAUTO_SUSPEND = 60

BMAX_CLUSTER_COUNT = 3

CMIN_CLUSTER_COUNT = 1

DAUTO_RESUME = TRUE

Attempts:

3 left

💡 Hint

Common Mistakes

Using AUTO_SUSPEND instead of MAX_CLUSTER_COUNT

Setting MIN_CLUSTER_COUNT without MAX_CLUSTER_COUNT

The MAX_CLUSTER_COUNT parameter enables multi-cluster warehouses by setting the maximum number of clusters.

2fill in blank

medium

Complete the code to set the minimum number of clusters for a multi-cluster warehouse.

Snowflake

ALTER WAREHOUSE my_wh SET [1] = 2;

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

AMIN_CLUSTER_COUNT

BMAX_CLUSTER_COUNT

CAUTO_SUSPEND

DAUTO_RESUME

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing MIN_CLUSTER_COUNT with MAX_CLUSTER_COUNT

Using AUTO_SUSPEND instead of cluster count

The MIN_CLUSTER_COUNT parameter sets the minimum number of clusters that remain active.

3fill in blank

hard

Fix the error in the code to enable auto-suspend for a multi-cluster warehouse.

Snowflake

ALTER WAREHOUSE my_wh SET AUTO_SUSPEND = [1];

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

A'TRUE'

BTRUE

C'60'

D60

Attempts:

3 left

💡 Hint

Common Mistakes

Using TRUE or 'TRUE' instead of a number

Using a string for the number instead of an integer

The AUTO_SUSPEND parameter expects a number representing seconds before suspension, not a boolean.

4fill in blank

hard

Fill both blanks to create a multi-cluster warehouse with minimum 2 and maximum 5 clusters.

Snowflake

CREATE WAREHOUSE multi_wh WITH WAREHOUSE_SIZE = 'MEDIUM' [1] [2];

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

AMIN_CLUSTER_COUNT = 2

BAUTO_RESUME = TRUE

CMAX_CLUSTER_COUNT = 5

DAUTO_SUSPEND = 300

Attempts:

3 left

💡 Hint

Common Mistakes

Using AUTO_RESUME or AUTO_SUSPEND instead of cluster counts

Setting only one of the cluster count parameters

Setting MIN_CLUSTER_COUNT and MAX_CLUSTER_COUNT defines the cluster range for the warehouse.

5fill in blank

hard

Fill all three blanks to alter a warehouse to enable auto-resume, set auto-suspend to 120 seconds, and max clusters to 4.

Snowflake

ALTER WAREHOUSE my_wh SET [1] = TRUE, [2] = [3], MAX_CLUSTER_COUNT = 4;

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

AAUTO_RESUME

BAUTO_SUSPEND

C120

DMIN_CLUSTER_COUNT

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing AUTO_RESUME and AUTO_SUSPEND parameters

Using a string instead of a number for AUTO_SUSPEND

AUTO_RESUME enables the warehouse to start automatically, AUTO_SUSPEND sets the idle time before suspension, and 120 is the time in seconds.