The correct answer is C. HEADER = TRUE .
When unloading data with the COPY INTO < location > command, the HEADER option specifies whether column names should be included in the output file.
Why C is correct:
HEADER = TRUE includes column headings in the unloaded file output.
Example:
COPY INTO @my_stage/output/
FROM my_table
FILE_FORMAT = (TYPE = PARQUET)
HEADER = TRUE;
Important note for exam review:
For CSV unloads, HEADER = TRUE includes column names in the first row. For Parquet unloads, Snowflake can use column names in the Parquet output metadata/schema when the header option is enabled.
Why the other options are incorrect:
A). PARSE_HEADER is a file format option used when loading CSV data with inferred column names. It is not the unload option for including headers.
B). SKIP_HEADER is used when loading files to skip header rows. It does not include headers during unloading.
D). This syntax is not the correct Snowflake unload option for column headers.
Official Snowflake documentation reference:
Snowflake documentation for COPY INTO < location > describes the HEADER option as specifying whether to include table column headings in the output files.
Reference: Snowflake Documentation - COPY INTO < location > ; Snowflake Documentation - Unloading data; SnowPro Core Study Guide - Data Loading and Unloading.