Explanation:
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.
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.