Answer: Use the COPY option SINGLE=TRUE.

The correct answer is B because the SINGLE=TRUE option in the COPY command is specifically designed to ensure that data unloaded into a stage is contained within a single file, regardless of the data size. This is documented in Snowflake's official documentation on data unloading considerations. Option A is incorrect because FILES=SINGLE is not a valid COPY option. Options C and D are incorrect because GET is used for downloading files from a stage to a local system, not for unloading data from Snowflake tables into a stage.

Author: LeetQuiz Editorial Team