Which Snowflake data types can be used to build nested hierarchical data? (Select TWO)

The correct answer is B. OBJECT C. VARIANT. Snowflake supports semi-structured data through three native types: VARIANT, OBJECT, and ARRAY. VARIANT (C) is the most flexible - it can store any value of any type, including entire JSON documents, XML, Avro, or Parquet structures, making it ideal for arbitrary nested…

Snowflake Cloud Data Platform Features and Architecture

Question

Options

AINTEGER
BOBJECT
CVARIANT
DVARCHAR
ELIST

How the community answered

(21 responses)

A
5% (1)
B
90% (19)
D
5% (1)

Explanation

Snowflake supports semi-structured data through three native types: VARIANT, OBJECT, and ARRAY. VARIANT (C) is the most flexible - it can store any value of any type, including entire JSON documents, XML, Avro, or Parquet structures, making it ideal for arbitrary nested hierarchical data. OBJECT (B) is a collection of key-value pairs (analogous to a JSON object) and directly supports nested structures when values are themselves OBJECTs or VARIANTs. INTEGER (A) and VARCHAR (D) are scalar types with no nesting capability. LIST (E) is not a valid Snowflake data type - the correct array type is ARRAY.

Topics

#Snowflake Data Types#Semi-structured Data#Nested Data#Hierarchical Data

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice