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.
Which command option should be used to guarantee that the data unloaded into a stage is contained within a single file?
A
Use the COPY option FILES=SINGLE.
B
Use the COPY option SINGLE=TRUE.
C
Use the GET option SINGLE=TRUE.
D
Use the GET option FILES=SINGLE.
No comments yet.