nerdexam
Snowflake

COF-C02 · Question #141

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

The correct answer is D. SINGLE=FALSE. The COPY INTO SQL command with the option SINGLE=FALSE is used to unload data into multiple files. This option allows the data to be split into multiple files during the unload process.

Data Loading and Unloading

Question

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

Options

  • ASINGLE=TRUE
  • BMULTIPLE=TRUE
  • CMULTIPLE=FALSE
  • DSINGLE=FALSE

How the community answered

(42 responses)
  • A
    5% (2)
  • B
    2% (1)
  • C
    2% (1)
  • D
    90% (38)

Explanation

The COPY INTO SQL command with the option SINGLE=FALSE is used to unload data into multiple files. This option allows the data to be split into multiple files during the unload process.

Topics

#COPY INTO unload#Data Unloading#Multiple Files#SQL Command

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice