SnowPro Core Certification — Question 909

Which data type can be used to load semi-structured data files directly, without explicitly describing the hierarchical structure of the data?

Answer options

• A. TEXT
• B. VARIANT
• C. VARCHAR
• D. VARBINARY

Correct answer: B

Explanation

The VARIANT data type is designed to handle semi-structured data, allowing for flexible storage of varying data formats without needing a predefined schema. TEXT, VARCHAR, and VARBINARY are not suitable for this purpose as they require a more fixed structure or are limited to specific data types.