Answer: Parquet, JSON

The question asks for two semi-structured file formats supported when unloading data from a Snowflake table. According to Snowflake documentation and the community discussion (with 100% consensus for DE), Parquet (D) and JSON (E) are semi-structured formats that Snowflake supports for unloading. Parquet is a columnar format that can handle complex nested data structures, while JSON is a widely used semi-structured format. ORC (A) is also semi-structured but not mentioned as supported for unloading in this context. XML (B) is semi-structured but not a primary unloading format in Snowflake. Avro (C) is semi-structured but not listed as a supported unloading format in the referenced documentation. The community discussion specifically references Snowflake documentation that confirms JSON and Parquet as semi-structured formats for unloading.

Author: LeetQuiz Editorial Team