Snowpro Core · Free Practice Question Easy
Question 89
Which data type in Snowflake is specifically designed for storing and querying semi-structured data?
-
A
ARRAY
-
B
OBJECT
-
C
STRING
-
D
VARIANT
Reveal correct answer
Correct answer: D
A.
While ARRAYS are used to store multiple elements, they are not specifically designed for semi-structured data as a whole. They can be part of semi-structured data but do not represent the entire dataset format.
B.
OBJECT is a data type that holds key-value pairs, which is useful in semi-structured data scenarios but is not the main data type Snowflake uses for handling complex semi-structured formats like JSON or XML.
C.
STRING is intended for storing plain text values and does not support the hierarchical and nested structures that semi-structured data often requires.
D.
VARIANT is the data type specifically built for storing and querying semi-structured data formats such as JSON, Avro, and Parquet. It supports flexible storage and querying of different data types, making it the correct answer.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
