A company is using Snowpipe to load JSON files from an external stage. They notice that some files are not being loaded and want to ensure that the pipe is correctly configured. Which of the following is a required step to set up Snowpipe for an external stage?

Use the PUT command to upload files to the stage.

Create a pipe with a COPY INTO statement that references the external stage and file format.

Create a task that runs the COPY INTO command periodically.

Manually run the COPY INTO command once to load existing files.

What is the purpose of the TRANSFORM parameter in COPY INTO?

To specify the file format of the source files

To specify transformations to apply to the data during loading

To specify the error handling behavior

To specify the target table schema

A data engineer needs to load a large historical dataset from files in an external cloud storage bucket into Snowflake. Which method is most appropriate for this one-time bulk load?

Use a data sharing share to load the data

Use the COPY INTO command to load the files from an external stage

Use Snowpipe to load the files automatically

Use an external function to load the data

Which approach allows you to transform data while loading it into a Snowflake table using COPY INTO?

Using a stored procedure to load data

Using a task to transform data after load

Using a SELECT statement in the COPY INTO command

SnowflakeSnowPro Advanced — Data Scientist

Domain 2Objective 2

Ingest and Prepare Data in Snowflake SNOWPRO-ADVANCED-DATA-SCIENTIST Practice Questions (Page 3)

Part of the Data Pipelining domain, which makes up ~15% of our current practice bank.

23questions here

5free pages

9concepts

Questions 11–15

11application · medium
A company is using Snowpipe to load JSON files from an external stage. They notice that some files are not being loaded and want to ensure that the pipe is correctly configured. Which of the following is a required step to set up Snowpipe for an external stage?
Select an answer first
12foundation · easy
What is the purpose of the TRANSFORM parameter in COPY INTO?
Select an answer first
13foundation · easy
A data engineer needs to load a large historical dataset from files in an external cloud storage bucket into Snowflake. Which method is most appropriate for this one-time bulk load?
Select an answer first
14foundation · easy
Which approach allows you to transform data while loading it into a Snowflake table using COPY INTO?
Select an answer first
15foundation · easy
Which clause in the COPY INTO command allows you to specify how to handle files that contain errors during loading?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to SNOWPRO-ADVANCED-DATA-SCIENTIST

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Snowflake. “SNOWPRO-ADVANCED-DATA-SCIENTIST” is a trademark of its owner, used for identification only.