SnowPro Core Certification — Question 1096

Why would a Snowflake user load JSON data into a VARIANT column instead of a string column?

Answer options

• 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.

Correct answer: C

Explanation

The correct answer is C because a VARIANT column is designed to store semi-structured data like JSON, allowing users to create complex data hierarchies. The other options are incorrect; VARIANT columns may not necessarily be more secure than string columns, and while they may compress data and improve query performance, these are not the primary reasons for choosing VARIANT for JSON.