Table and Data Types - 3

What are the four table types supported in Snowflake?

​ ​ ​

• Permanent
• Temporary
• Transient
• External
• Virtual

You are loading data into a landing table and several users will be taking data from the table, transforming it, and storing into different permanent tables.

If you wanted to minimize storage costs used by the landing table, what type of table would you use?

• temporary

• transient

• permanent

• external

Answer explanation

A transient table because it isn't covered by fail safe and only one day of time travel. A temporary table wouldn't work because we want it to be accessed by multiple users.

You create a table with this statement:

CREATE TABLE my_table (c1 INT);

When you DESCRIBE the table, what data type will you see listed for c1?

• INTEGER

• NUMBER

• INT

• NUMBER(38,0)

You create a table with this statement:

CREATE TABLE table1 (c1 CHAR);

When you DESCRIBE the table, what data type will you see listed for c1?

• VARCHAR (1)

• VARCHAR

• VARCHAR(16777216)

• STRING

Which of the following constraints does Snowflake maintain?

• UNIQUE

• PRIMARY KEY

• FOREIGN KEY

• NOT NULL

Answer explanation

Snowflake maintains all of these constraints, but the only one it ENFORCES is NOT NULL

How to we turn off Snowflake's default behavior of using implicit transactions?

ALTER SESSION SET (a)  

• AUTOCOMMIT = FALSE;
• TRANSATION = TRUE;

• COMMIT = TRUE;

• AUTOCOMMIT = TRUE;