Answer: JSON, Parquet

The question asks for file formats that support unloading semi-structured data in Snowflake. According to Snowflake documentation and the community discussion consensus (with BD having 90% support and multiple upvoted comments confirming BD), JSON and Parquet are the correct answers. While Snowflake supports loading multiple semi-structured formats including Avro, ORC, and XML, the unloading capability is specifically documented for JSON and Parquet formats. The community discussion shows strong agreement on BD, with references to official Snowflake documentation confirming that JSON and Parquet are the supported formats for unloading semi-structured data.

Author: LeetQuiz Editorial Team