Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 338

What are value types that a VARIANT column can store? (Choose two.)

    Correct Answer: B, D

    VARIANT columns can store semi-structured data types such as OBJECT and ARRAY. These types provide the flexibility needed for storing hierarchical and complex data structures commonly found in formats like JSON.

Discussion
harshagc180Options: BD

Answer : OBJECT and ARRAY

SV1122Options: BD

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

SnowProCertDec22Options: BD

OBJECT and ARRAY

EmiBOptions: BD

OBJECT and ARRAY

learner2023Options: BD

BD is correct. https://docs.snowflake.com/en/sql-reference/data-types-semistructured

Afzy

C and D is correct

HeetecOptions: BD

B and D

AmitsnowflakeOptions: BD

VARIANT can store a value of any other type, including OBJECT and ARRAY.

MultiCloudIronManOptions: BD

Correct