Which data types does Snowflake support when querying semi-structured data? (Choose two.)
Which data types does Snowflake support when querying semi-structured data? (Choose two.)
Snowflake supports the VARIANT and ARRAY data types when querying semi-structured data. The VARIANT type can store semi-structured data in formats like JSON, Avro, ORC, Parquet, and even XML and it allows the data to be queried directly. The ARRAY type is used to store arrays of VARIANT values, which is useful for data that is represented in an array format.
A&D https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html
Variant and Array
A,D Variant and Array
Answer : Variant and Array https://docs.snowflake.com/en/user-guide/semistructured-intro.html#loading-semi-structured-data
Variant and array
A and D are correct
A and D are correct
Correct
A y D correct
https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html
d y a are correct