Answer: SINGLE = TRUE

The correct answer is C because the SINGLE = TRUE parameter in the COPY INTO command explicitly instructs Snowflake to generate a single output file when unloading data. This is the direct and intended method for creating a single file output. Option A (PARTITION BY) is for splitting data into multiple files based on expressions, which is the opposite of what's needed. Option B (MAX_FILE_SIZE = 0) is invalid syntax and doesn't create a single file. Option D (OVERWRITE = TRUE) controls whether existing files are overwritten but doesn't affect the number of output files created. The community discussion shows 100% consensus on answer C with upvoted comments confirming it's the straightforward correct choice.

Author: LeetQuiz Editorial Team