Warehouse selection strategies in Snowflake - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to select a warehouse for running a query.

Snowflake

USE WAREHOUSE [1];

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

ACOMPUTE_WH

BANALYTICS_WH

CDEFAULT_WH

DDATA_WH

Attempts:

3 left

💡 Hint

Common Mistakes

Using a warehouse name that does not exist.

Forgetting to use the USE WAREHOUSE command before running queries.

The USE WAREHOUSE command sets the active warehouse. Here, DATA_WH is the correct warehouse name to select.

2fill in blank

medium

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

Snowflake

CREATE WAREHOUSE my_wh WAREHOUSE_SIZE = '[1]';

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

AXSMALL

BLARGE

CMEDIUM

DXLARGE

Attempts:

3 left

💡 Hint

Common Mistakes

Using lowercase size names which are invalid.

Using sizes not supported by Snowflake.

The WAREHOUSE_SIZE parameter defines the size of the warehouse. MEDIUM is a valid size option.

3fill in blank

hard

Fix the error in the warehouse auto-suspend configuration.

Snowflake

ALTER WAREHOUSE my_wh SET AUTO_SUSPEND = [1];

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

A300

B'300'

C'off'

Doff

Attempts:

3 left

💡 Hint

Common Mistakes

Putting the number in quotes, making it a string.

Using the string 'off' instead of 0 to disable.

The AUTO_SUSPEND parameter expects an integer number of seconds. The correct value is 300 without quotes.

4fill in blank

hard

Fill both blanks to create a warehouse with multi-cluster enabled and set minimum clusters.

Snowflake

CREATE WAREHOUSE multi_wh [1] = TRUE MIN_CLUSTER_COUNT = [2];

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

AMULTI_CLUSTER_WAREHOUSE

BMAX_CLUSTER_COUNT

CMIN_CLUSTER_COUNT

DAUTO_SUSPEND

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing MAX_CLUSTER_COUNT with MIN_CLUSTER_COUNT.

Not enabling MULTI_CLUSTER_WAREHOUSE before setting cluster counts.

MULTI_CLUSTER_WAREHOUSE enables multi-cluster warehouses. MIN_CLUSTER_COUNT sets the minimum number of clusters.

5fill in blank

hard

Fill all three blanks to alter a warehouse to set auto-resume, size, and max clusters.

Snowflake

ALTER WAREHOUSE my_wh SET AUTO_RESUME = [1], WAREHOUSE_SIZE = '[2]', MAX_CLUSTER_COUNT = [3];

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

ATRUE

BLARGE

C5

DFALSE

Attempts:

3 left

💡 Hint

Common Mistakes

Using FALSE for AUTO_RESUME when auto-resume is desired.

Not quoting the warehouse size string.

Setting MAX_CLUSTER_COUNT to a string instead of a number.

AUTO_RESUME should be set to TRUE to resume automatically. WAREHOUSE_SIZE is set to LARGE. MAX_CLUSTER_COUNT is set to 5 to limit clusters.