Answer: Binary file in Parquet, Newline Delimited JSON

The correct answers are B (Binary file in Parquet) and D (Newline Delimited JSON). According to Snowflake documentation on supported file formats for unloading data, Parquet and NDJSON (Newline Delimited JSON) are explicitly supported formats for unloading semi-structured data. The community discussion shows 100% consensus on BD, with multiple comments referencing the official Snowflake documentation that confirms these formats. Option A (Binary file in Avro) is not supported for unloading in Snowflake. Option C (Comma-separated JSON) is not a standard format and not supported. Option E (Plain text file containing XML elements) is not supported for unloading semi-structured data in Snowflake.

Author: LeetQuiz Editorial Team