SnowPro Core Certification — Question 1332

While unloading data into a stage, how can the user ensure that the output will be a single file?

Answer options

• A. Use the COPY option FILES=SINGLE.
• B. Use the COPY option SINGLE=TRUE.
• C. Use the GET option SINGLE=TRUE.
• D. Use the GET option FILES=SINGLE.

Correct answer: B

Explanation

The correct answer is B, as using the COPY option SINGLE=TRUE specifically instructs the system to generate a single output file during the unloading process. The other options either refer to incorrect syntax or commands that do not achieve the desired outcome of producing a single file.