SnowPro Core Certification — Question 879

What data type is used to ingest semi-structured data into a Snowflake table?

Answer options

• A. BOOLEAN
• B. NUMBER
• C. VARBINARY
• D. VARIANT

Correct answer: D

Explanation

The correct answer is VARIANT, as it is specifically designed to store semi-structured data like JSON, Avro, or XML in Snowflake. The other options, BOOLEAN, NUMBER, and VARBINARY, are intended for different data types and cannot accommodate the flexibility required for semi-structured formats.