Creating tables (permanent, temporary, transient) in Snowflake - Interactive Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a permanent table named employees.

Snowflake

CREATE [1] TABLE employees (id INT, name STRING);

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

ATEMPORARY

BPERMANENT

CTRANSIENT

DVOLATILE

Attempts:

3 left

💡 Hint

Common Mistakes

Using TEMPORARY or TRANSIENT keywords instead of PERMANENT.

Using VOLATILE which is not valid in Snowflake.

Permanent tables are created with the keyword PERMANENT or no keyword at all. Here, we explicitly use PERMANENT to create a permanent table.

2fill in blank

medium

Complete the code to create a temporary table named temp_sales.

Snowflake

CREATE [1] TABLE temp_sales (sale_id INT, amount FLOAT);

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

APERMANENT

BGLOBAL

CTRANSIENT

DTEMPORARY

Attempts:

3 left

💡 Hint

Common Mistakes

Using PERMANENT or TRANSIENT instead of TEMPORARY.

Using GLOBAL which is not a valid table type in Snowflake.

Temporary tables are created with the keyword TEMPORARY. They exist only during the user session.

3fill in blank

hard

Fix the error in the code to create a transient table named orders.

Snowflake

CREATE [1] TABLE orders (order_id INT, order_date DATE);

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

ATEMPORARY

BPERMANENT

CTRANSIENT

DVOLATILE

Attempts:

3 left

💡 Hint

Common Mistakes

Using TEMPORARY or PERMANENT instead of TRANSIENT.

Using VOLATILE which is invalid in Snowflake.

Transient tables are created with the keyword TRANSIENT. They do not have fail-safe but data persists beyond the session.

4fill in blank

hard

Fill both blanks to create a temporary table named session_data with two columns.

Snowflake

CREATE [1] TABLE session_data (user_id [2], login_time TIMESTAMP);

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

ATEMPORARY

BINT

CSTRING

DPERMANENT

Attempts:

3 left

💡 Hint

Common Mistakes

Using PERMANENT instead of TEMPORARY.

Using STRING for user_id when it should be INT.

The table is temporary, so use TEMPORARY. The user_id column is an integer, so use INT as the data type.

5fill in blank

hard

Fill all three blanks to create a transient table named product_info with columns id, name, and price.

Snowflake

CREATE [1] TABLE product_info (id [2], name [3], price FLOAT);

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

ATRANSIENT

BINT

CSTRING

DTEMPORARY

Attempts:

3 left

💡 Hint

Common Mistakes

Using TEMPORARY instead of TRANSIENT.

Mixing up data types for id and name columns.

The table is transient, so use TRANSIENT. The id column is an integer (INT) and the name column is text (STRING).