SnowPro Core Certification — Question 830

Which data types optimally store semi-structured data? (Choose two.)

Answer options

• A. ARRAY
• B. CHARACTER
• C. STRING
• D. VARCHAR
• E. VARIANT

Correct answer: A, E

Explanation

The ARRAY and VARIANT data types are designed to handle semi-structured data effectively. ARRAY allows for storing collections of items, while VARIANT can accommodate various data types, making them more flexible for semi-structured formats compared to CHARACTER, STRING, and VARCHAR, which are more suitable for structured data.