Answer: JSON, Parquet

The question asks which file formats are supported by the COPY INTO <location> command for unloading data, requiring selection of two options. According to Snowflake documentation (referenced in the community discussion), JSON and Parquet are explicitly supported formats for unloading data. The community discussion shows 100% consensus on BD (JSON and Parquet), with upvoted comments confirming these as correct and providing official documentation links. Avro (A) is not supported for unloading in Snowflake, ORC (C) is primarily for loading data but not unloading, and XML (E) is not a supported unload format.

Author: LeetQuiz Editorial Team