SnowPro Core Certification — Question 168

What COPY INTO SQL command should be used to unload data into multiple files?

Answer options

• A. SINGLE=TRUE
• B. MULTIPLE=TRUE
• C. MULTIPLE=FALSE
• D. SINGLE=FALSE

Correct answer: D

Explanation

The correct answer is D, as setting SINGLE=FALSE allows data to be unloaded into multiple files. Options A and C restrict the output to a single file, while option B does not address the requirement for multiple files correctly.