Answer: LZO

The question asks about compression formats supported for Parquet files when using the COPY INTO command to unload data. According to Snowflake documentation and the community discussion, Parquet files support specific compression formats: AUTO (defaults to SNAPPY), LZO, SNAPPY, and NONE. The community discussion consistently identifies LZO as a valid option (with 100% consensus in answers_community and multiple upvoted comments), while noting that GZIP is not supported for Parquet (as confirmed by user BigDataBB's comment showing an error when trying GZIP). BROTLI and ZSTD are mentioned in the context of general unloading but are not supported for Parquet files specifically. Therefore, LZO is the correct answer from the given choices.

Author: LeetQuiz Editorial Team