Snowpro Core · Free Practice Question Easy
Question 7
VARIANT is used to FLATTEN hierarchical data. (True / False)
- A FALSE
- B TRUE
Reveal correct answer
Correct answer: A
Explanation
VARIANT is a data type that can hold a value of any other data type (including ARRAY and OBJECT). VARIANT is used to build and store hierarchical data. VARIANT is not a function to FLATTEN. FLATTEN is a table function that is used to produce a lateral view of a VARIANT, OBJECT, or ARRAY column.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
