Q: 6
Which data types does Snowflake support when querying semi-structured data? (Select TWO)
Options
Discussion
Not sure why C gets picked sometimes, pretty sure it's A and B. VARIANT is for flexible schema, and ARRAY handles nested lists. XML looks tempting but it's not a separate native type. Disagree?
Its A and B, unless they're asking about something super old or some edge-case. VARIANT is basically for JSON/XML/etc, and ARRAY handles nested objects. VARCHAR won't parse the structure, just stores as text. Maybe I'm missing a Snowflake twist but I don't think so-correct me if I'm off.
Probably A and B, but honestly not 100% sure because I get confused with all the types in Snowflake. Does VARIANT cover everything or do you need ARRAY too? Hoping someone can confirm.
Be respectful. No spam.
