What is Snowflake - Interactive Quiz & Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a Snowflake database named 'sales_db'.

Snowflake

CREATE DATABASE [1];

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

Asales_db

Bmy_table

Cwarehouse1

Duser_account

Attempts:

3 left

💡 Hint

Common Mistakes

Using a table name instead of a database name.

Using a warehouse or user name instead of a database name.

The command CREATE DATABASE sales_db; creates a new database named 'sales_db' in Snowflake.

2fill in blank

medium

Complete the code to create a Snowflake warehouse named 'compute_wh'.

Snowflake

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

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

Acompute_wh

Bsales_db

Cuser_role

Ddata_schema

Attempts:

3 left

💡 Hint

Common Mistakes

Using a database name instead of a warehouse name.

Using a role or schema name instead of a warehouse name.

The command CREATE WAREHOUSE compute_wh WITH WAREHOUSE_SIZE = 'SMALL'; creates a compute warehouse named 'compute_wh' with a small size.

3fill in blank

hard

Fix the error in the code to select all data from the table 'customers' in the 'sales_db' database.

Snowflake

SELECT * FROM [1].customers;

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

Acompute_wh

Buser_role

Csales_db

Dwarehouse1

Attempts:

3 left

💡 Hint

Common Mistakes

Using warehouse or role names instead of the database name.

Omitting the database name when required.

The correct syntax to select from a table in a specific database is database_name.schema_name.table_name. Here, sales_db.customers is incomplete because it misses the schema name. The correct fully qualified name should include the schema, for example, sales_db.public.customers.

4fill in blank

hard

Fill both blanks to grant the role 'analyst' the ability to read data from the 'sales_db' database.

Snowflake

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

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

AUSAGE

BSELECT

Canalyst

DCREATE

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'SELECT' privilege instead of 'USAGE' for database access.

Confusing role names with privilege types.

The USAGE privilege is required to access objects (like schemas and tables) within the database. Granting it to the role 'analyst' is a key step to enable reading data from the database.

5fill in blank

hard

Fill all three blanks to create a table named 'orders' with columns 'id' (integer) and 'amount' (float) in the 'sales_db' database and 'public' schema.

Snowflake

CREATE TABLE [1].[2].orders (id [3], amount FLOAT);

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

Asales_db

Bpublic

CINT

Dwarehouse1

Attempts:

3 left

💡 Hint

Common Mistakes

Using warehouse name instead of database or schema.

Using wrong data type for 'id' column.

The syntax CREATE TABLE database.schema.table is used. 'id' column type is 'INT' for integer.