How does Snowflake handle the bulk unloading of data into single or multiple files?

Question

Options

• AIt assigns each unloaded data file a unique name.
• BIt uses the put command to download the data by default.
• CIt uses COPY INTO <location> for bulk unloading where the default option is SINGLE - TRUE.
• DIt uses COPY INTO <location> to copy the data from a table into one or more files in an external

• A
  94% (32)
• C
  3% (1)
• D
  3% (1)

Explanation

When using COPY INTO <location> for bulk unloading, Snowflake automatically assigns each output file a unique name (typically a UUID-based name with a file extension). By default, Snowflake splits data across multiple files (the SINGLE option defaults to FALSE, not TRUE - making option C incorrect). Option B is wrong because the PUT command is used to upload files to a stage, not to download/unload data. Option D is partially correct in describing the command used, but the key distinguishing characteristic is that each file gets a unique name automatically.

No community discussion yet for this question.