ExamGecko
Question list
Search
Search

Question 113 - COF-R02 discussion

Report
Export

Which data types does Snowflake support when querying semi-structured data? (Select TWO)

A.
VARIANT
Answers
A.
VARIANT
B.
ARRAY
Answers
B.
ARRAY
C.
VARCHAR
Answers
C.
VARCHAR
D.
XML
Answers
D.
XML
E.
BLOB
Answers
E.
BLOB
Suggested answer: A, B

Explanation:

https://docs.snowflake.com/en/user-guide/semistructured-intro.html#label-loading-semi-structured-data

A VARIANT stores semi-structured data in Snowflake. It can store a value of any other type, including OBJECT and ARRAY.

The maximum length of a VARIANT is 16 MB.

A Snowflake ARRAY is similar to an array in many other programming languages. An ARRAY contains 0 or more pieces of data. Each element is accessed by specifying its position in the array.

asked 23/09/2024
Dirk van der Watt
29 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first