Which data types can be used in Snowflake to store semi-structured data? (Select TWO)

The correct answer is A. ARRAY E. VARIANT. Snowflake supports the storage of semi-structured data using the ARRAY and VARIANT data types. The ARRAY data type can directly contain VARIANT, and thus indirectly contain any other data type, including itself. The VARIANT data type can store a value of any other type…

Snowflake Cloud Data Platform Features and Architecture

Question

Options

AARRAY
BBLOB
CCLOB
DJSON
EVARIANT

How the community answered

(54 responses)

A
87% (47)
B
2% (1)
C
4% (2)
D
7% (4)

Explanation

Snowflake supports the storage of semi-structured data using the ARRAY and VARIANT data types. The ARRAY data type can directly contain VARIANT, and thus indirectly contain any other data type, including itself. The VARIANT data type can store a value of any other type, including OBJECT and ARRAY, and is often used to represent semi-structured data formats like JSON, Avro, ORC, Parquet, or XML.

Topics

#Data Types#Semi-structured Data#VARIANT#ARRAY

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice