What are supported file formats for unloading data from Snowflake? (Choose three.)

Snowflake's COPY INTO command is used to unload (export) data from a table into files in an internal or external stage. The command explicitly supports three file formats for this operation: CSV (the default), JSON, and Parquet. These formats are specified using the TYPE file format option within the command. While Snowflake supports loading data from other formats like ORC, AVRO, and XML, these are not available as output formats for unloading operations.

A. XML: Snowflake supports loading semi-structured XML data but does not support unloading data into the XML format.
D. ORC: ORC is a supported format for loading data into Snowflake tables, but it is not a supported format for unloading data.
E. AVRO: AVRO is a supported format for loading data into Snowflake tables, but it is not a supported format for unloading data.

1. Snowflake Documentation. (n.d.). COPY INTO . Retrieved from https://docs.snowflake.com/en/sql-reference/sql/copy-into-location.

Reference Details: In the "Format Type Options (formatTypeOptions)" section

under the TYPE = fileformattype parameter

the documentation explicitly lists the supported values for unloading as CSV

JSON

and PARQUET.

2. Snowflake Documentation. (n.d.). Introduction to Data Unloading. Retrieved from https://docs.snowflake.com/en/user-guide/data-unload-overview.

Reference Details: The "Supported File Formats for Unloading" section states: "The COPY INTO command supports unloading data from a table into files in the following formats: CSV (comma-delimited)

JSON

Parquet."