SOL-C01 practice question 6 of 30

Which of the following data format supported to unload semi-structured data from Snowflake? (Choose any 2 options)

Full set: 214 questions
Answer options
A: JSON Correct answer
B: CSV
C: Parquet Correct answer
D: XML
Correct Answer:
A. JSON; C. Parquet
Explanation

When unloading semi-structured VARIANT data via COPY INTO , Snowflake supports JSON and PARQUET file formats, preserving the nested structure. CSV is strictly tabular text and XML is unsupported for unload operations.

Why Incorrect

B. CSV can be used to unload relational data but does not preserve semi-structured hierarchy.
D. XML is not listed among supported unload formats in Snowflake documentation.

References

1. Snowflake Documentation – “Unloading Data: Supported File Formats” lists JSON and PARQUET for semi-structured data (docs.snowflake.com, §Supported Formats, accessed 2024-04-24).

2. Snowflake Documentation – “COPY INTO … TYPE = JSON | PARQUET” examples (docs.snowflake.com, §Examples).

Scroll to Top