Which data types can be used in Snowflake to store semi-structured data? (Choose two.)
Which data types can be used in Snowflake to store semi-structured data? (Choose two.)
Snowflake supports storing semi-structured data using the ARRAY and VARIANT data types. ARRAY allows for the storage of an ordered list of elements, and VARIANT is a flexible data type that can store a variety of semi-structured data including JSON, Avro, ORC, Parquet, and XML.
correct
AE correct
AE https://docs.snowflake.com/en/sql-reference/data-types-semistructured
Why not JSON and Variant?
JSON is file type, not Data type