SnowPro Core Certification — Question 533

How does Snowflake handle the bulk unloading of data into single or multiple files?

Answer options

• 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.

Correct answer: A

Explanation

The correct answer is A, as Snowflake generates unique names for each file created during the bulk unloading process, ensuring no conflicts. Option B is incorrect because the PUT command is used for uploading data, not unloading. Option C is misleading since while COPY INTO does facilitate bulk unloading, the default setting for SINGLE is TRUE only when specifically configured, and D is too restrictive as it suggests unloading can only occur in external stages.