How does Snowflake handle the bulk unloading of data into single or multiple 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.
The Answer Is:
A
This question includes an explanation.
Explanation:
When unloading data, Snowflake assigns each file a unique name to ensure there is no overlap or confusion between files. This is part of the bulk unloading process where data is exported from Snowflake tables into flat files3.
COF-C03 PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 65% Discount on All Products,
Use Coupon: "ac4s65"