SnowPro Core Certification — Question 612

Which native data types are used for storing semi-structured data in Snowflake? (Choose two.)

Answer options

• A. NUMBER
• B. OBJECT
• C. STRING
• D. VARCHAR
• E. VARIANT

Correct answer: B, E

Explanation

The correct answer is B and E because OBJECT and VARIANT are specifically designed in Snowflake to handle semi-structured data formats like JSON. The other options, NUMBER, STRING, and VARCHAR, are used for structured data and do not provide the same flexibility for semi-structured formats.