SnowPro Core Certification — Question 743

What column type does a Kafka connector store formatted information in a single column?

Answer options

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

Correct answer: D

Explanation

The correct answer is VARIANT, as it is designed to store semi-structured data, which is essential for handling formatted information in a single column. The other options, such as ARRAY, OBJECT, and VARCHAR, do not provide the same level of flexibility for semi-structured data storage.