Which semi-structured file formats are supported when unloading data from a table? (Select TWO).

The correct answer is D. Parquet E. JSON. When unloading (exporting) data from a Snowflake table, the supported semi-structured formats are Parquet (D) and JSON (E). ORC (A) and Avro (C) are supported for data loading (ingestion) into Snowflake but are not supported for unloading data out of Snowflake. XML (B) is not…

Data Loading and Unloading

Question

Options

AORC
BXML
CAvro
DParquet
EJSON

How the community answered

(58 responses)

A
3% (2)
B
2% (1)
C
2% (1)
D
93% (54)

Explanation

When unloading (exporting) data from a Snowflake table, the supported semi-structured formats are Parquet (D) and JSON (E). ORC (A) and Avro (C) are supported for data loading (ingestion) into Snowflake but are not supported for unloading data out of Snowflake. XML (B) is not supported for either structured loading or unloading in Snowflake. For unloading, Snowflake supports CSV (delimited), JSON, and Parquet.

Topics

#Data Unloading#File Formats#Semi-structured Data

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice