The correct answer is B. To unload data to one output file .
The COPY INTO < location > command unloads data from a Snowflake table or query result into files in a stage. By default, Snowflake may unload data into multiple files depending on the amount of data and warehouse parallelism.
Why B is correct:
The SINGLE = TRUE option tells Snowflake to unload the result into a single file instead of multiple files.
Example:
COPY INTO @my_stage/output_file.csv
FROM my_table
FILE_FORMAT = (TYPE = CSV)
SINGLE = TRUE;
This is useful when a downstream process expects one output file.
Why the other options are incorrect:
A. SINGLE = TRUE does not control the file format or data type.
C. It is not an access-control setting for limiting a user’s behavior.
D. It does not control the number of attempts to load or unload data.
Official Snowflake documentation reference:
Snowflake documentation for COPY INTO < location > describes SINGLE as an option that specifies whether to generate a single output file or multiple files.
