Answer: file_extension

The correct answer is C (file_extension) because it directly controls the file extension of the output file when unloading data. According to Snowflake documentation and the community discussion consensus (with multiple upvoted comments supporting C), the file_extension option specifies the extension for files unloaded to a stage. When unloading to CSV format, setting file_extension = '.csv' ensures the output file has the .csv extension, which aligns with preserving the exact table name specification. While option D (single) is mentioned in some comments, it controls whether data is unloaded as a single file or multiple files, not the file naming or extension directly. Options A (encoding) and B (escape) are unrelated to file naming. The community discussion shows strong support for C with detailed reasoning from the official documentation.

Author: LeetQuiz Editorial Team