Which copy INTO command outputs the data into one file?
A.
SINGLE=TRUE
B.
MAX_FILE_NUMBER=1
C.
FILE_NUMBER=1
D.
MULTIPLE=FAISE
The Answer Is:
B
This question includes an explanation.
Explanation:
The COPY INTO command in Snowflake can be configured to output data into a single file by setting the MAX_FILE_NUMBER option to 1. This option limits the number of files generated by the command, ensuring that only one file is created regardless of the amount of data being exported.
[References:, [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation on Data Unloading, ]
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"