Answer: FILE_EXTENSION

The correct answer is C (FILE_EXTENSION) because when unloading data to a stage in Snowflake, the FILE_EXTENSION option explicitly specifies the file extension for output files, such as .csv for CSV files or .json for JSON files. This ensures the unloaded files have the correct format-specific suffix. The other options are incorrect: A (PARSE_HEADER) is for loading data to parse CSV headers, B (TRIM_SPACE) is for trimming whitespace during loading, and D (SKIP_HEADER) is for skipping header rows during loading, none of which apply to unloading data. The community discussion confirms this with 100% consensus on C and detailed reasoning.

Author: LeetQuiz Editorial Team