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 questionsWhen 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.
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.
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).
Keep practicing
Take the free SOL-C01 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other SOL-C01 practice questions
- Question 1Which Snowflake object is a logical container for schemas and other database objects?
- Question 2How can Python variable substitution be performed in Snowflake notebooks?
- Question 3Which SQL command is commonly used to load structured data from a stage into a Snowflake …
- Question 4Which command can be used to query the Information Schema in Snowflake to retrieve a list…
- Question 5Which command is synonymous with the LIST command in Snowflake?
- Question 7Which of the following file formats can be processed by the PARSE_DOCUMENT function?
