Creating a Snowflake account and workspace - Interactive Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a new Snowflake user with a password.

Snowflake

CREATE USER new_user PASSWORD = '[1]';

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

A'MySecurePass123!'

Bnew_password

Cpassword123

D'12345'

Attempts:

3 left

💡 Hint

Common Mistakes

Not enclosing the password in single quotes

Using a weak password that Snowflake rejects

The password must be a string enclosed in single quotes and follow Snowflake's password policy. 'MySecurePass123!' is a valid example.

2fill in blank

medium

Complete the command to create a new Snowflake warehouse named 'compute_wh'.

Snowflake

CREATE WAREHOUSE [1] WITH WAREHOUSE_SIZE = 'SMALL' AUTO_SUSPEND = 300;

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

Adefault_wh

Bcompute_wh

Cwarehouse1

Dmywarehouse

Attempts:

3 left

💡 Hint

Common Mistakes

Using a different warehouse name than intended

Omitting the warehouse name

The warehouse name must match the intended name exactly. Here, 'compute_wh' is the correct warehouse name.

3fill in blank

hard

Fix the error in the command to create a database named 'sales_db'.

Snowflake

CREATE DATABASE [1];

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

A'sales_db'

Bsales db

Csales_db

Dsales-db

Attempts:

3 left

💡 Hint

Common Mistakes

Using single quotes around the database name

Including spaces or hyphens in the name

Database names should not be enclosed in quotes unless using double quotes for case sensitivity. Using sales_db without quotes is correct.

4fill in blank

hard

Fill both blanks to grant the role 'analyst' access to the 'sales_db' database.

Snowflake

GRANT [1] ON DATABASE [2] TO ROLE analyst;

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

AUSAGE

BSELECT

Csales_db

Dsales

Attempts:

3 left

💡 Hint

Common Mistakes

Granting SELECT on the database (SELECT is for tables)

Using incorrect database name

To allow a role to use a database, the USAGE privilege is granted on the database name 'sales_db'.

5fill in blank

hard

Fill all three blanks to create a Snowflake role 'data_engineer' and grant it to user 'new_user'.

Snowflake

CREATE ROLE [1]; GRANT ROLE [2] TO USER [3];

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

Adata_engineer

Cnew_user

Dadmin

Attempts:

3 left

💡 Hint

Common Mistakes

Using different role names in create and grant commands

Granting role to wrong user

The role 'data_engineer' is created and then granted to the user 'new_user'. Both blanks for the role name must match exactly.