Exam COF-C02 Topic 1 Question 190 Discussion

Actual exam question for Snowflake's COF-C02 exam
Question #: 190
Topic #: 1
While unloading data into a stage, how can the user ensure that the output will be a single file?

Suggested Answer: B Vote an answer

To ensure that the output will be a single file when unloading data into a stage, you should use the COPY option SINGLE=TRUE. This option specifies that the result of the COPY INTO command should be written to a single file, rather than multiple files.
Reference:
Snowflake Documentation: COPY INTO <location>

by Jerry at Apr 28, 2026, 05:08 AM

Limited Time Offer

15%

Off

Get Premium COF-C02 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