SnowPro Core Certification — Question 1122

How can a 5 GB table be downloaded into a single file MOST efficiently?

Answer options

• A. Keep the default MAX_FILE_SIZE to 16 MB.
• B. Set the default MAX_FILE_SIZE to 5 GB.
• C. Set the SINGLE parameter to TRUE.
• D. Use a regular expression in the stage specifications of the COPY command.

Correct answer: C

Explanation

The correct answer is C because setting the SINGLE parameter to TRUE allows the data to be written to a single output file, which is the goal. Options A and B deal with file size limits that would not accomplish the task effectively, and option D involves using a regular expression, which does not directly relate to consolidating the output into one file.