Which data formats are supported by Snowflake when unloading semi-structured data? (Select TWO).

The correct answer is B. Binary file in Parquet D. Newline Delimited JSON. Snowflake supports a variety of file formats for unloading semi-structured data, among which Parquet and Newline Delimited JSON (NDJSON) are two widely used formats. B . Binary file in Parquet: Parquet is a columnar storage file format optimized for large-scale data processing…

Data Loading and Unloading

Question

Options

ABinary file in Avro
BBinary file in Parquet
CComma-separated JSON
DNewline Delimited JSON
EPlain text file containing XML elements

How the community answered

(42 responses)

A
7% (3)
B
88% (37)
C
2% (1)
E
2% (1)

Explanation

Snowflake supports a variety of file formats for unloading semi-structured data, among which Parquet and Newline Delimited JSON (NDJSON) are two widely used formats. B . Binary file in Parquet: Parquet is a columnar storage file format optimized for large-scale data processing and analysis. It is especially suited for complex nested data structures. D . Newline Delimited JSON (NDJSON): This format represents JSON records separated by newline characters, facilitating the storage and processing of multiple, separate JSON objects in a single file. These formats are chosen for their efficiency and compatibility with data analytics tools and ecosystems, enabling seamless integration and processing of exported data.

Topics

#Data Unloading#Semi-structured Data#File Formats#JSON#Parquet

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice