
Explanation:
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.
Ultimate access to all questions.
No comments yet.