Answer-first summary for fast verification
Answer: It assigns each unloaded data file a unique name.
The correct answer is A because Snowflake's COPY INTO <location> command for bulk unloading assigns each unloaded data file a unique name, especially when unloading into multiple files (which is the default with SINGLE = FALSE). This is explicitly stated in Snowflake documentation and supported by the community discussion where A has the highest upvotes (68% community selection) and detailed reasoning citing official docs. Option C is incorrect because it falsely claims the default SINGLE option is TRUE when it's actually FALSE. Option B is wrong as PUT is for uploading, not downloading/unloading. Option D is incomplete as COPY INTO location can unload to external stages but also cloud storage locations, not just external stages.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How does Snowflake manage the bulk unloading of data into one or more files?
A
It assigns each unloaded data file a unique name.
B
It uses the PUT command to download the data by default.
C
It uses COPY INTO [location] for bulk unloading where the default option is SINGLE = TRUE.
D
It uses COPY INTO [location] to copy the data from a table into one or more files in an external stage only.
No comments yet.