Exam SOL-C01 Topic 1 Question 78 Discussion

Actual exam question for Snowflake's SOL-C01 exam
Question #: 78
Topic #: 1
You are loading data from a CSV file stored in an Amazon S3 bucket into a Snowflake table named `CUSTOMER DATA. The CSV file contains a header row, and the data is comma- separated. The 'CUSTOMER DATA table has columns `customer_id', 'first_name', and 'email'.
You want to use a named file format object called `CSV FORMAT which you have already created. You also want to skip the header row and only load data where the column is not null.
Which of the following `COPY INTO' statement achieves this most efficiently and correctly?

Suggested Answer: D Vote an answer

Option D is the most correct because it efficiently copies the data from the stage, using a named file format, skips the header and sets error handling. The WHERE clause to filter null emails cannot be directly used within COPY INTO. Options A, B and C, is incorrect, as 'WHERE clause and 'SKIP_HEADER = 1' is not applicable as the way written in the option. E is incorrect as its using select statement and it cannot be used in 'COPY INTO'

by Victor at Mar 21, 2026, 02:38 AM

Limited Time Offer

15%

Off

Get Premium SOL-C01 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10