Answer-first summary for fast verification
Answer: A VARIANT column can be used to create a data hierarchy and a string column cannot.
The correct answer is C because VARIANT columns in Snowflake are specifically designed for semi-structured data like JSON, allowing users to create data hierarchies and query nested elements directly using dot notation or other JSON functions. This enables more efficient data exploration and manipulation compared to storing JSON as plain strings. Option A is incorrect because VARIANT columns don't inherently provide more security than string columns. Option B is incorrect because both VARIANT and string columns support compression in Snowflake. Option D is incorrect because querying VARIANT columns can sometimes be slower than structured columns due to the need to parse semi-structured data, though they offer more flexibility for JSON data.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What are the advantages of loading JSON data into a VARIANT column compared to a STRING column in Snowflake?
A
A VARIANT column is more secure than a string column.
B
A VARIANT column compresses data and a string column does not.
C
A VARIANT column can be used to create a data hierarchy and a string column cannot.
D
A VARIANT column will have a better query performance than a string column.
No comments yet.