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

The correct answer is B. JSON C. Parquet F. CSV. Snowflake supports three file formats for UNLOADING (exporting) data: CSV (F), JSON (B), and Parquet (C). It is important to distinguish between loading and unloading: while Snowflake can LOAD data from additional formats such as AVRO (E), ORC (D), and XML (A), these formats…

Data Loading and Unloading

Question

Options

AXML
BJSON
CParquet
DORC
EAVRO
FCSV

How the community answered

(20 responses)

A
5% (1)
B
90% (18)
D
5% (1)

Explanation

Snowflake supports three file formats for UNLOADING (exporting) data: CSV (F), JSON (B), and Parquet (C). It is important to distinguish between loading and unloading: while Snowflake can LOAD data from additional formats such as AVRO (E), ORC (D), and XML (A), these formats are not supported for unloading/exporting data. XML is not supported in either direction as a structured format for bulk operations. Always remember: for unloading, the supported formats are CSV, JSON, and Parquet only.

Topics

#data unloading#file formats#external stages

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice