SnowPro Core Certification — Question 998

Which Snowflake data types can be used to build nested hierarchical data? (Choose two.)

Answer options

• A. INTEGER
• B. OBJECT
• C. VARIANT
• D. VARCHAR
• E. LIST

Correct answer: B, C

Explanation

The correct answers are B (OBJECT) and C (VARIANT) because these types are specifically designed to handle semi-structured data and can store complex nested structures. The other options, such as INTEGER, VARCHAR, and LIST, do not support the necessary hierarchical arrangements as effectively as OBJECT and VARIANT.