Exam SOL-C01 Topic 2 Question 132 Discussion

Actual exam question for Snowflake's SOL-C01 exam
Question #: 132
Topic #: 2
A Snowflake table 'product catalog' exists with columns 'product id', 'product_name', and 'price'.
You have a pipe-delimited file in an external stage named 's3 stage' containing product data, but some rows have missing values for the 'price' column. You want to load the data, replacing missing prices with a default value of 0. Which approach is the MOST appropriate to handle missing values during the 'COPY INTO' operation?

Suggested Answer: B Vote an answer

Using a transformation within the 'COPY INTO' statement (option B) allows you to directly handle missing values during the data loading process, providing the most efficient solution. You can utilize a 'CASE' statement or similar logic within the column mapping of the 'COPY INTO' statement to replace nulls with the default value of 0. Option A is not valid. Option C requires additional steps. Option D skips over valuable data, and Option E is false because of the transformation support.

by Shirley at Jan 27, 2026, 01:14 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