Here are all the actual test exam dumps for IT exams. Most people prepare for the actual exams with our test dumps to pass their exams. So it's critical to choose and actual test pdf to succeed.

Exam COF-C03 Topic 1 Question 277 Discussion

Actual exam question for Snowflake's COF-C03 exam
Question #: 277
Topic #: 1
How can staged files be removed during data loading once the files have loaded successfully?

Suggested Answer: B Vote an answer

To remove staged files during data loading after they have been successfully loaded, the PURGE copy option is used in Snowflake.
PURGE Option: This option automatically deletes files from the stage after they have been successfully copied into the target table.
Usage:
FROM @my_stage
FILE_FORMAT = (type = 'csv')
PURGE = TRUE;
References:
Snowflake Documentation on COPY INTO

by Leopold at Feb 19, 2026, 02:00 AM

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.