Which Snowflake command can be used to unload the result of a query to a single file?
A.
Use COPY INTO followed by a GET command to download the file.
B.
Use COPY INTO followed by a put command to download the file.
C.
Use COPY INTO with SINGLE = TRUE followed by a GET command to download the file.
D.
Use COPY INTO with SINGLE = TRUE followed by a PUT command to download the file.
The Answer Is:
C
This question includes an explanation.
Explanation:
The Snowflake command to unload the result of a query to a single file is COPY INTO with SINGLE = TRUE followed by a GET command to download the file. This command unloads the query result into a single file in the specified internal stage
COF-C02 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"