Data Loading & Unloading Quiz

Question 1

What is the purpose of an internal stage in Snowflake? Choose one correct value.
- To permanently store table data
- To store metadata information/statistics for tables
- A place to store connector configuration files
- An area to temporarily store data used in the data loading process

Answer 1

An area to temporarily store data used in the data loading process

Question 2

Which symbol(s) are used when referencing a named stage object via SQL?

Answer 2

@

Question 3

A user stage must be manually created by a user via SQL. True or false?

Answer 3

False

Question 4

What are Stages called that store data outside of Snowflake?

Answer 4

EXTERNAL Stage

Question 5

What is the function of the keyword OVERWRITE in the insert statement? Choose one correct value.
- OVERWRITE will append records to a table
- OVERWRITE will overwrite the latest version of a table with the new rules
- OVERWRITE will overwrite only the records which have the same ID field
- OVERWRITE will truncate before new values are inserted

Answer 5

• OVERWRITE will truncate before new values are inserted

Question 6

What is the function of the PUT command? Choose one correct value.
- Transfer files from a Snowflake Stage to a local file system
- Transfer files from a local file system to an external stage
- Transfer files from a local file system to an internal stage
- Load data from an internal stage to a table.

Answer 6

Transfer files from a local file system to an internal stage

Question 7

PUT cannot be executed from within worksheets. True or false?

Answer 7

True

Question 8

Which copy option for the COPY INTO <table> command allows you to provide a regular expression to extract files to load? Choose one correct value.
- PATTERN
- REGULAR_EXPRESSION
- REGULAR PATTERN
- REGEX

Answer 8

• PATTERN

Question 9

For how many days is load history stored in metadata for a pipe to prevent reloading the same files into a table?

Answer 9

14

Question 10

Which type of workload does Snowpipe facilitate? Choose one correct value.
- Bulk load of smaller data files
- Continuous load of larger data file
- Continuous load of smaller data files
- Bulk lad of larger data files

Answer 10

• Continuous load of smaller data files