Which semi-structured file formats are supported when unloading data from a table? (Select TWO).

Which semi-structured file formats are supported when unloading data from a table? (Select TWO).
A . ORC
B . XML
C . Avro
D . Parquet
E . JSON

View Answer

Answer: D, E

Explanation:

Semi-structured JSON, Parquet

Snowflake supports unloading data in several semi-structured file formats, including Parquet and JSON. These formats allow for efficient storage and querying of semi-structured data, which can be loaded directly into Snowflake tables without requiring a predefined schema12.

https://docs.snowflake.com/en/user-guide/data-unload-prepare.html#:~:text=Supported%20File%20Formats,-The%20following%20file&text=Delimited%20(CSV%2C%20TSV%2C%20etc.)