Clustering keys for large tables in Snowflake - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a clustering key on the 'customer_id' column.

Snowflake

ALTER TABLE sales_data CLUSTER BY ([1]);

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

Acustomer_id

Bproduct_id

Cregion

Dorder_date

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing a column that is rarely used in queries.

Using a column with low cardinality as clustering key.

The clustering key should be set on the 'customer_id' column to optimize queries filtering by customer.

2fill in blank

medium

Complete the code to create a clustering key on multiple columns: 'region' and 'order_date'.

Snowflake

ALTER TABLE sales_data CLUSTER BY ([1], order_date);

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

Aproduct_id

Bcustomer_id

Cregion

Dsales_amount

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping the order of clustering columns.

Using columns not suitable for clustering.

To cluster by 'region' and 'order_date', the first column must be 'region'.

3fill in blank

hard

Fix the error in the clustering key syntax to cluster by 'order_date'.

Snowflake

ALTER TABLE sales_data CLUSTER BY [1];

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

A(order_date)

B'order_date'

Corder_date

D[order_date]

Attempts:

3 left

💡 Hint

Common Mistakes

Using quotes around column names.

Using brackets instead of parentheses.

The clustering key columns must be enclosed in parentheses without quotes.

4fill in blank

hard

Fill both blanks to create a clustering key on 'region' and 'customer_id'.

Snowflake

ALTER TABLE sales_data CLUSTER BY ([1], [2]);

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

Aregion

Border_date

Ccustomer_id

Dproduct_id

Attempts:

3 left

💡 Hint

Common Mistakes

Reversing the order of clustering columns.

Using columns not relevant for query patterns.

The clustering key should be on 'region' first, then 'customer_id' to optimize queries filtering by these columns.

5fill in blank

hard

Fill all three blanks to create a clustering key on 'region', 'order_date', and 'product_id'.

Snowflake

ALTER TABLE sales_data CLUSTER BY ([1], [2], [3]);

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

Aregion

Border_date

Cproduct_id

Dcustomer_id

Attempts:

3 left

💡 Hint

Common Mistakes

Incorrect order of clustering columns.

Including columns that are not useful for clustering.

The clustering key columns are 'region', then 'order_date', then 'product_id' to optimize multi-dimensional queries.