Snowflake vs traditional data warehouses - Interactive Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a Snowflake warehouse with the correct size.

Snowflake

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

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

AX-LARGE

BMEDIUM

CLARGE

DSMALL

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing a size too small or too large for typical workloads.

The correct warehouse size for a balanced Snowflake warehouse is MEDIUM.

2fill in blank

medium

Complete the code to pause a Snowflake warehouse.

Snowflake

ALTER WAREHOUSE my_warehouse [1];

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

ASUSPEND

BSTART

CRESUME

DSTOP

Attempts:

3 left

💡 Hint

Common Mistakes

Using START or RESUME instead of SUSPEND.

To save costs, you pause a Snowflake warehouse using the SUSPEND command.

3fill in blank

hard

Fix the error in the Snowflake SQL to create a table with clustering keys.

Snowflake

CREATE TABLE sales_data (id INT, amount FLOAT) CLUSTER BY ([1]);

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

Aid

Bamount

Cdate

Dregion

Attempts:

3 left

💡 Hint

Common Mistakes

Using columns not defined in the table like 'date' or 'region'.

Clustering keys should be columns present in the table. Here, id is valid.

4fill in blank

hard

Fill both blanks to create a Snowflake database and schema.

Snowflake

CREATE DATABASE [1]; CREATE SCHEMA IF NOT EXISTS [1].[2];

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

Asales_db

Bmarketing_db

Cpublic

Danalytics

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing database and schema names or using non-existent schemas.

The database is named sales_db and the schema is public, which is the default schema.

5fill in blank

hard

Fill all three blanks to grant usage and select privileges on a schema to a role.

Snowflake

GRANT [1] ON SCHEMA [2] TO ROLE [3];

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

AUSAGE

Bsales_schema

Canalyst_role

DSELECT

Attempts:

3 left

💡 Hint

Common Mistakes

Using SELECT privilege on schema instead of USAGE.

Granting USAGE on schema sales_schema to role analyst_role allows the role to access the schema.