SnowPro Core Certification — Question 1331

Which command should be used to generate a single file when unloading data from a Snowflake table into a file?

Answer options

• A. PARTITION BY [expr]
• B. MAX_FILE_SIZE = 0
• C. SINGLE = TRUE
• D. OVERWRITE = TRUE

Correct answer: C

Explanation

The correct answer is C, as setting SINGLE = TRUE ensures that the data is outputted into a single file. Options A and B do not control the output file count, and option D relates to overwriting existing files rather than the number of files generated.