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

Get Premium COF-R02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Owen

2 days ago

Haha, this is like a game of 'which one of these is not like the other?' I'm going with C and D, just to be safe.

upvoted 0 times

...

Velda

9 days 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

...

Arminda

13 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

...

Desiree

16 days ago

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

upvoted 0 times

...

Sommer

17 days ago

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

upvoted 0 times

...

Theron

17 days ago

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

upvoted 0 times

...

William

20 days ago

I think VARIANT column can store STRUCT and OBJECT.

upvoted 0 times

...