nerdexam
SnowflakeSnowflake

COF-C02 · Question #457

COF-C02 Question #457: Real Exam Question with Answer & Explanation

The correct answer is B: Binary file in Parquet. 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 an

Data Loading and Unloading

Question

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

Options

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

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 PracticeBrowse All COF-C02 Questions