SnowPro Core Certification — Question 857

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

Answer options

• A. Binary file in Avro
• B. Binary file in Parquet
• C. Comma-separated JSON
• D. Newline Delimited JSON
• E. Plain text file containing XML elements

Correct answer: B, D

Explanation

The correct answers are B and D because Snowflake supports unloading semi-structured data in both Binary file in Parquet format and Newline Delimited JSON format. Options A, C, and E are not supported formats for unloading semi-structured data in Snowflake.