
Table and Data Types - 3
Authored by Sydney Cucchiara
Instructional Technology
Professional Development
Used 3+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
6 questions
Show all answers
1.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
What are the four table types supported in Snowflake?
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)
TRANSATION = TRUE;
COMMIT = TRUE;
AUTOCOMMIT = TRUE;
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
10 questions
All I know About Google Meet
Quiz
•
Professional Development
10 questions
Review of Course 5 weeks 1-2
Quiz
•
Professional Development
10 questions
Evaluación del Tema 2 y 3. Módulo I - Integración de las TIC
Quiz
•
Professional Development
10 questions
Business Analytics
Quiz
•
Professional Development
10 questions
BASICS OF MANAGEMENT
Quiz
•
Professional Development
10 questions
Lesson 4: SD Methodologies. Discussing Waterfall, Agile & Scrum
Quiz
•
Professional Development
10 questions
Drills and Drilling
Quiz
•
12th Grade - Professi...
10 questions
CURDEV - Sociological Foundation
Quiz
•
Professional Development
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade