Which data types can be used in a Snowflake table that holds semi-structured data? (Select TWO).

The correct answer is A. ARRAY D. VARIANT. Snowflake provides three native semi-structured data types: VARIANT (stores any JSON, Avro, ORC, Parquet, or XML value), ARRAY (stores arrays of VARIANT values), and OBJECT (stores key-value pairs). VARIANT is the most flexible and foundational type. BINARY is a structured type…

Snowflake Cloud Data Platform Features and Architecture

Question

Options

AARRAY
BBINARY
CTEXT
DVARIANT
EVARCHAK

How the community answered

(48 responses)

A
90% (43)
B
2% (1)
C
6% (3)
E
2% (1)

Explanation

Snowflake provides three native semi-structured data types: VARIANT (stores any JSON, Avro, ORC, Parquet, or XML value), ARRAY (stores arrays of VARIANT values), and OBJECT (stores key-value pairs). VARIANT is the most flexible and foundational type. BINARY is a structured type for storing raw byte data, and TEXT/VARCHAR are standard string types - neither is designed for semi-structured data. ARRAY and VARIANT are the correct choices here.

Topics

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

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice