Answer: JSON, Delimited (CSV, TSV, etc.)

The question asks for two file formats supported for unloading data from Snowflake. According to Snowflake documentation and the community discussion consensus (with 100% agreement on BE), the supported formats for unloading are JSON, Delimited files (CSV, TSV, etc.), and Parquet. However, Parquet is not listed as an option. Among the given choices, JSON (B) and Delimited files like CSV/TSV (E) are explicitly supported for unloading operations. Avro (A) is primarily for loading data into Snowflake, not unloading. ORC (C) is supported for loading but not for unloading. XML (D) is not a native Snowflake unloading format. The community discussion consistently confirms BE as correct, with references to official documentation.

Author: LeetQuiz Editorial Team