SnowPro Core Certification — Question 726

A user wants to unload data from a relational table into a CSV file in an external stage. The table must be named exactly as specified by the user.

Which file format option MUST be used to do this?

Answer options

• A. encoding
• B. escape
• C. file_extension
• D. single

Correct answer: C

Explanation

The correct answer is C, as specifying the 'file_extension' is necessary to ensure the data is formatted correctly as a CSV file. Options A and B are related to data handling and formatting but do not pertain to file naming conventions, while option D does not apply to setting the file format for export.