SnowPro Core Certification — Question 621

A user has semi-structured data to load into Snowflake but is not sure what types of operations will need to be performed on the data.

Based on this situation, what type of column does Snowflake recommend be used?

Answer options

• A. ARRAY
• B. OBJECT
• C. TEXT
• D. VARIANT

Correct answer: D

Explanation

The VARIANT column type in Snowflake is designed to hold semi-structured data, allowing for flexibility in the data format and structure. The other options, like ARRAY and OBJECT, are more specific to certain structures and may not be suitable for all semi-structured data scenarios. TEXT is not suitable for storing semi-structured formats as it is intended for plain string data.