Table and Data Types - 3

Table and Data Types - 3

Professional Development

6 Qs

quiz-placeholder

Similar activities

3D printing

3D printing

Professional Development

10 Qs

câu hỏi trắc nghiệm môn tin học lớp 5

câu hỏi trắc nghiệm môn tin học lớp 5

Professional Development

10 Qs

GSuite Quiz

GSuite Quiz

Professional Development

10 Qs

Web Technologies

Web Technologies

Professional Development

10 Qs

Minecraft

Minecraft

KG - Professional Development

10 Qs

Bài tập lớp 12

Bài tập lớp 12

Professional Development

10 Qs

LESSON 1: INTRODUCTION TO OPEN EDUCATIONAL RESOURCES

LESSON 1: INTRODUCTION TO OPEN EDUCATIONAL RESOURCES

Professional Development

10 Qs

TLE - Google Classroom

TLE - Google Classroom

Professional Development

10 Qs

Table and Data Types - 3

Table and Data Types - 3

Assessment

Quiz

Instructional Technology

Professional Development

Practice Problem

Medium

Created by

Sydney Cucchiara

Used 3+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

6 questions

Show all answers

1.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

What are the four table types supported in Snowflake?

​ ​ ​

Permanent
Temporary
Transient
External

Virtual

2.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

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.

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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)

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

5.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

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

6.

DROPDOWN QUESTION

45 sec • 1 pt

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;