ExamGecko
Question list
Search
Search

Question 107 - COF-R02 discussion

Report
Export

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

A.
STRUCT
Answers
A.
STRUCT
B.
OBJECT
Answers
B.
OBJECT
C.
BINARY
Answers
C.
BINARY
D.
ARRAY
Answers
D.
ARRAY
E.
CLOB
Answers
E.
CLOB
Suggested answer: B, D

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.

https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html#:~:text=VARIANT-,Characteristics%20of%20a%20VARIANT,a%20VARIANT%20is%2016%20MB.

asked 23/09/2024
Saley SEINI
34 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first