Exam SOL-C01 Topic 1 Question 223 Discussion

Actual exam question for Snowflake's SOL-C01 exam
Question #: 223
Topic #: 1
You have a large CSV file stored in AWS S3 that you need to load into a Snowflake table called
'SALES DATA'. The CSV file is compressed using GZIP, and it contains a header row that you want to skip. The table 'SALES DATA' already exists with the correct schema. You want to optimize the data loading process by using a named file format object and explicitly specifying the virtual warehouse. The S3 bucket is properly configured for Snowflake access. Which of the following SQL statements is the MOST efficient and correct way to load the data?

Suggested Answer: E Vote an answer

Option E is the most correct and efficient. First, it creates the named file format to encapsulate the CSV- specific settings (compression, header skipping). This promotes reusability and readability. Then, the COPY INTO statement uses this named format, skips files on error, and specifies the 'WAREHOUSE for explicit control, improving performance. Option A doesn't use a named file format or specify a warehouse. Option B is missing the creation of the file format object and the skip header parameter, will throw an error. Option C uses 'COMPRESSION = AUTO' , but explicitly stating the compression type (GZIP) is better for performance. Option D does not create file format and so the query would fail.

by Stanley at Nov 22, 2025, 07:54 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