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?
Wouldn't XML (D) only be the right pick if the question was about file formats not native data types?
D’s only valid if they specifically ask about ingestible file formats, not data types-tricky wording but makes all the difference here.
Snowflake keeps mixing up file formats and actual types, super annoying. A and B are the native data types for semi-structured stuff, VARIANT for blobs like JSON and ARRAY to handle nested lists. Pretty sure that's what they're after here.
B and D tbh
A/B tbh, but only because XML is a file format, not a native type. If they’d asked about file formats you can ingest, D would flip the answer. Seen similar wording mess people up on practice sets.
B/A tbh, that's what shows up in the Snowflake official guide and most practice sets for semi-structured queries.
A/B for sure. VARIANT is Snowflake's main datatype for any semi-structured formats like JSON, and ARRAY lets you handle lists inside that data. XML is a file format you can load, but it's not used as a native datatype in queries. Pretty confident on these two but correct me if I'm missing something.
Seen this in practice exams, they want A and B for Snowflake data types.
A and B imo, encountered exactly similar question in my exam. VARIANT and ARRAY are the supported types for semi-structured data.
Be respectful. No spam.
