Which data types optimally store semi-structured data? (Select TWO).

The correct answer is A. ARRAY E. VARIANT. Snowflake provides three native semi-structured data types: VARIANT, ARRAY, and OBJECT. VARIANT is the most flexible - it can store any semi-structured value including JSON, Avro, ORC, Parquet, and XML data. ARRAY is a typed collection that stores ordered lists of values. Both…

Snowflake Cloud Data Platform Features and Architecture

Question

Options

AARRAY
BCHARACTER
CSTRING
DVARCHAR
EVARIANT

How the community answered

(27 responses)

A
89% (24)
B
4% (1)
C
7% (2)

Explanation

Snowflake provides three native semi-structured data types: VARIANT, ARRAY, and OBJECT. VARIANT is the most flexible - it can store any semi-structured value including JSON, Avro, ORC, Parquet, and XML data. ARRAY is a typed collection that stores ordered lists of values. Both are purpose-built for semi-structured data and support dot/bracket notation for querying nested elements. CHARACTER, STRING, and VARCHAR are all character/text types and can technically store semi-structured data as raw text, but they offer no structural awareness, traversal, or optimization - making them poor choices for this use case.

Topics

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

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice