Which copy INTO command outputs the data into one file?

Which copy INTO command outputs the data into one file?
A . SINGLE=TRUE
B . MAX_FILE_NUMBER=1
C . FILE_NUMBER=1
D . MULTIPLE=FAISE

View Answer

Answer: B

Explanation:

The COPY INTO command in Snowflake can be configured to output data into a single file by setting the MAX_FILE_NUMBER option to 1. This option limits the number of files generated by the command, ensuring that only one file is created regardless of the amount of data being exported.

Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

Snowflake Documentation on Data Unloading