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

The correct answer is B. OBJECT D. ARRAY. Characteristics of a VARIANT A VARIANT can store a value of any other type, including OBJECT and ARRAY. The maximum length of a VARIANT is 16 MB.

Snowflake Overview and Architecture

Question

Options

ASTRUCT
BOBJECT
CBINARY
DARRAY
ECLOB

How the community answered

(26 responses)

A
12% (3)
B
81% (21)
C
4% (1)
E
4% (1)

Explanation

Characteristics of a VARIANT A VARIANT can store a value of any other type, including OBJECT and ARRAY. The maximum length of a VARIANT is 16 MB.

Topics

#VARIANT#semi-structured data#OBJECT#ARRAY

Community Discussion

No community discussion yet for this question.

Full COF-R02 Practice