Snowflake Exam COF-R02 Topic 5 Question 40 Discussion

Actual exam question for Snowflake's COF-R02 exam

Question #: 40
Topic #: 5

[All COF-R02 Questions]

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

ASTRUCT

BOBJECT

CBINARY

DARRAY

ECLOB

Show Suggested Answer

Suggested Answer: C

by Arminda at Sep 08, 2024, 11:46 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

5 hours ago

Wait, isn't CLOB a Character Large Object? Why would that be an option for a VARIANT column? Seems like a trick question to me.

upvoted 0 times

...

4 days ago

Hmm, I'm not sure about that. I think it can also store objects, so B should be one of the answers too.

upvoted 0 times

...

7 days ago

I'm not sure about that, I think VARIANT column can store BINARY and CLOB.

upvoted 0 times

...

8 days ago

I agree with William, VARIANT column can definitely store STRUCT and OBJECT.

upvoted 0 times

...

8 days ago

I think C and D are the correct answers. VARIANT can store binary data and arrays, right?

upvoted 0 times

...

11 days ago

I think VARIANT column can store STRUCT and OBJECT.

upvoted 0 times

...