Which native data types are used for storing semi-structured data in Snowflake? (Select TWO)

The correct answer is B. OBJECT E. VARIANT. Snowflake provides three native semi-structured data types: VARIANT, OBJECT, and ARRAY. VARIANT (E) is the most flexible - it can store any value including JSON, Avro, ORC, Parquet, or XML data, and can hold scalars, arrays, or objects. OBJECT (B) specifically represents a…

Snowflake Cloud Data Platform Features and Architecture

Question

Options

ANUMBER
BOBJECT
CSTRING
DVARCHAR
EVARIANT

How the community answered

(31 responses)

A
6% (2)
B
90% (28)
C
3% (1)

Explanation

Snowflake provides three native semi-structured data types: VARIANT, OBJECT, and ARRAY. VARIANT (E) is the most flexible - it can store any value including JSON, Avro, ORC, Parquet, or XML data, and can hold scalars, arrays, or objects. OBJECT (B) specifically represents a collection of key-value pairs (similar to a JSON object). NUMBER, STRING, and VARCHAR are all structured/scalar data types used for relational data, not semi-structured data.

Topics

#Semi-structured data#Data types#VARIANT#OBJECT

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice