SOL-C01 practice question 21 of 30
Which data type in Snowflake is commonly used for storing semi-structured data?
Full set: 214 questionsThe VARIANT data type is Snowflake's universal type designed specifically for storing and querying semi-structured data. It can natively ingest formats like JSON, Avro, ORC, Parquet, and XML without requiring a predefined schema. This allows for flexible data loading and direct querying of the hierarchical structure within the data, making it the most common and powerful choice for this purpose.
A. BLOB: This data type is for storing unstructured binary data, like image or audio files, not for semi-structured data that requires querying of its internal elements.
B. JSON: Snowflake does not have a native JSON data type. It uses the VARIANT type to store, optimize, and query JSON-formatted data.
D. VARCHAR: Storing semi-structured data as a text string in a VARCHAR column prevents the use of Snowflake's optimized functions for querying nested structures.
- Snowflake Documentation, "Semi-structured Data Types", Section: VARIANT. This section states, "VARIANT can store values of any other type, including OBJECT and ARRAY. It is the idiomatic type for storing semi-structured data in Snowflake."
- Snowflake Documentation, "Introduction to Semi-structured Data", This page details how Snowflake uses the VARIANT data type to load and operate on semi-structured data such as JSON.
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 6Which of the following data format supported to unload semi-structured data from Snowflak…
