Which of the following data format supported to unload semi-structured data from Snowflake? (Choose any 2 options)
Correct Answer: A,C
Snowflake supports unloading semi-structured data specifically intoJSONandParquetformats. JSON preserves semi-structured hierarchy and nested fields, making it ideal for interchange, backup, and integration with downstream systems. Parquet provides columnar, compressed, and metadata-rich storage well-suited for analytical reprocessing in data lakes or other systems. CSV is not semi-structured and cannot represent nested data accurately. XML, although a semi-structured format, is not supported by Snowflake as an unload format.
When performing COPY INTO <location>, users can specify FILE_FORMAT with TYPE=JSON or TYPE=PARQUET to export semi-structured content efficiently.