What are value types that a VARIANT column can store? (Select TWO)

The correct answer is B. OBJECT: An object is a collection of key-value pairs in JSON, and a VARIANT column can D. ARRAY: An array is an ordered list of zero or more values, which can be of any variant-. A VARIANT column in Snowflake is designed to store semi-structured data and natively supports two compound types: (B) OBJECT - a collection of key-value pairs analogous to a JSON object; and (D) ARRAY - an ordered list of zero or more values, analogous to a JSON array. These…

Storage and Data Protection

Question

Options

ASTRUCT
BOBJECT: An object is a collection of key-value pairs in JSON, and a VARIANT column can
CBINARY
DARRAY: An array is an ordered list of zero or more values, which can be of any variant-
ECLOB

How the community answered

(25 responses)

A
4% (1)
B
92% (23)
E
4% (1)

Explanation

A VARIANT column in Snowflake is designed to store semi-structured data and natively supports two compound types: (B) OBJECT - a collection of key-value pairs analogous to a JSON object; and (D) ARRAY - an ordered list of zero or more values, analogous to a JSON array. These are the two primary semi-structured container types in Snowflake's type system. STRUCT (A) is not a Snowflake semi-structured type. BINARY (C) is a separate scalar column type in Snowflake, not a VARIANT sub-type. CLOB (E) is an Oracle/SQL concept for large character objects and does not exist in Snowflake.

Topics

#VARIANT data type#Semi-structured data#JSON#Data types

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice