Level Up: Data Loading

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