Why Snowflake separates compute from storage - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a virtual warehouse in Snowflake.

Snowflake

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

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

Amy_warehouse

Bstorage_account

Cdatabase_name

Duser_role

Attempts:

3 left

💡 Hint

Common Mistakes

Using storage or database names instead of warehouse name.

The warehouse name identifies the compute resource in Snowflake.

2fill in blank

medium

Complete the code to create a database in Snowflake.

Snowflake

CREATE DATABASE [1];

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

Asales_db

Bcompute_cluster

Cwarehouse_size

Duser_role

Attempts:

3 left

💡 Hint

Common Mistakes

Using compute or role names instead of database name.

The database stores data separately from compute in Snowflake.

3fill in blank

hard

Fix the error in the command to start a warehouse.

Snowflake

ALTER WAREHOUSE [1] RESUME;

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

Astorage_account

Bsales_db

Cmy_warehouse

Duser_role

Attempts:

3 left

💡 Hint

Common Mistakes

Trying to resume a database or storage instead of warehouse.

Only a warehouse (compute) can be resumed, not a database or storage.

4fill in blank

hard

Fill both blanks to create a warehouse with auto suspend and resume enabled.

Snowflake

CREATE WAREHOUSE my_warehouse WITH AUTO_SUSPEND = [1] AUTO_RESUME = [2];

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

A300

BTRUE

CFALSE

D0

Attempts:

3 left

💡 Hint

Common Mistakes

Using FALSE for auto resume disables it.

Using 0 disables auto suspend.

Auto suspend time is in seconds (300 = 5 minutes), and auto resume is enabled with TRUE.

5fill in blank

hard

Fill all three blanks to query data using a warehouse and database.

Snowflake

USE WAREHOUSE [1];
USE DATABASE [2];
SELECT * FROM [3].customers LIMIT 5;

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

Amy_warehouse

Bsales_db

Cpublic

Duser_role

Attempts:

3 left

💡 Hint

Common Mistakes

Using role instead of schema.

Mixing warehouse and database names.

You select the warehouse (compute), then the database (storage), then the schema (public) to query data.