Level 6 - Data Loading

Question 1

In a load process, data arrives at these Snowflake objects in what sequence?

Answer 1

Stage -> Pipe -> Table

Question 2

When deciding whether to use bulk loading or Snowpipe, which factors should you consider?

Answer 2

How often you will load the data
Location of data (local system or cloud)
Number of files you will load at one time

Question 3

Snowflake supports landing data into which locations?

Answer 3

Internal stage on cloud storage platform
External stage on cloud storage platform

Question 4

When loading data in Snowflake, which statements are true?

Answer 4

You can query a portion of data in external cloud storage without loading into Snowflake.
The Snowflake Data Load wizard has a limitation on file size.

Question 5

Who can provide the compute resource used by Snowflake for data loading jobs?

Answer 5

User-managed virtual warehouse
Snowflake-managed serverless compute