Level Up: Data Loading

Ace your homework & exams now with Quizwiz!

In a load process, data arrives at these Snowflake objects in what sequence? 1 2 3 Table Stage Pipe

1 -- Stage 2 -- Pipe 3 -- Table

When deciding whether to use bulk loading or Snowpipe, which factors should you consider? Select the correct options from the list A. How often you will load the data B. Location of data (local system or cloud) C. Data format (structured or semi-structured) D. Number of files you will load at one time

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

When loading data in Snowflake, which two are true? Select the correct options from the list A. All external cloud storage services charge the same data transfer price. B. You can query a portion of data in external cloud storage without loading into Snowflake. C. The Snowflake Data Load wizard has a limitation on file size. D. The COPY INTO command cannot be used to load single files.

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

True or False: Snowflake supports landing data into an internal stage on your local system.

False

True or False: The compute resource used by Snowflake for data loading jobs can be provided by hardware provisioned by user directly from cloud providers.

False

True or False: Snowflake supports landing data into an external stage on cloud storage platform.

True

True or False: Snowflake supports landing data into an internal stage on cloud storage platform.

True

True or False: The compute resource used by Snowflake for data loading jobs can be provided by Snowflake-managed serverless compute.

True

True or False: The compute resource used by Snowflake for data loading jobs can be provided by user-managed virtual warehouse.

True


Related study sets

Econ 40 [Cengage Test Question Compilation List]

View Set

BUS COM C. 14, BCOM 3360 chapter 13

View Set

Crisis Intervention Training (CIT)

View Set

Advanced Word Power: Chapter 8-9

View Set

ECON 1311 - Exam 1 (assignment 1)

View Set

Test your Level of English Grammar/Vocabulary

View Set