Answer: Set the SINGLE parameter to TRUE.

The question asks for the MOST efficient method to download a 5 GB table into a single file. Option C (Set the SINGLE parameter to TRUE) is the correct answer because when using the COPY INTO command to unload data, setting SINGLE = TRUE forces all data to be written to a single file, which directly addresses the requirement. This is documented in Snowflake's official documentation on unloading considerations. Option A (Keep default MAX_FILE_SIZE to 16 MB) would create multiple small files, not a single file. Option B (Set MAX_FILE_SIZE to 5 GB) might create a single file if the data fits exactly, but it's not guaranteed and less direct than SINGLE = TRUE. Option D (Use regex in stage specifications) is unrelated to controlling file count during unload operations. The community discussion shows 100% consensus on C with a reference to Snowflake documentation confirming this approach.

Author: LeetQuiz Editorial Team