A retail company receives sales transaction files from hundreds of stores throughout the day. The data must appear in a Snowflake table within minutes of each file landing in an external stage. The team wants to avoid manual intervention and minimize per-load cost. Which approach should they use?

Use a single COPY INTO command each day after all store files have arrived.

Set up a Snowpipe with an event notification from the external stage to load new files automatically.

Manually run COPY INTO whenever new files are noticed.

Schedule a COPY INTO command to run every hour using a task.

Which of the following is a valid transformation that can be applied during a COPY INTO load?

Join multiple source files together

CAST a source field to a different data type

Create a new table automatically

Apply a window function to the data

A data engineer is loading a CSV file that has a few rows with incorrect data types (e.g., a string in a numeric column). They want to load the valid rows and skip the invalid ones, but they also want to capture the errors for later analysis. Which approach should they use?

Use ON_ERROR = CONTINUE and then query the COPY_HISTORY table function to review the errors.

Use VALIDATION_MODE = RETURN_ERRORS to see the errors, then run the load again without the option.

Use ON_ERROR = ABORT_STATEMENT to stop the load and then manually fix the file.

Use FORCE = TRUE to load all rows, including the invalid ones.

A company loads daily CSV files from an external stage into Snowflake. After a successful load, they want the source files to be automatically removed from the stage to avoid reprocessing. Which COPY INTO option should they use?

VALIDATION_MODE = RETURN_ERRORS

SnowPro® Core Certification

Domain 4Objective 1

Load Data Using COPY INTO and Snowpipe COF-C03 Practice Questions (Page 1)

Part of the Data Loading, Unloading, and Connectivity domain, which accounts for 18% of the COF-C03 exam.

32questions here

7free pages

10concepts

18%of the exam

Questions 1–5

1application · medium
A retail company receives sales transaction files from hundreds of stores throughout the day. The data must appear in a Snowflake table within minutes of each file landing in an external stage. The team wants to avoid manual intervention and minimize per-load cost. Which approach should they use?
Select an answer first
2foundation · easy
Which of the following is a valid transformation that can be applied during a COPY INTO load?
Select an answer first
3expert · hard
A data engineer is loading a CSV file that has a few rows with incorrect data types (e.g., a string in a numeric column). They want to load the valid rows and skip the invalid ones, but they also want to capture the errors for later analysis. Which approach should they use?
Select an answer first
4foundation · easy
Which file format type is used to load semi-structured data stored in a JSON format?
Select an answer first
5application · easy
A company loads daily CSV files from an external stage into Snowflake. After a successful load, they want the source files to be automatically removed from the stage to avoid reprocessing. Which COPY INTO option should they use?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to COF-C03

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. “COF-C03” is a trademark of its owner, used for identification only.