Which native data types are used for storing semi-structured data in Snowflake? (Choose two.)
Which native data types are used for storing semi-structured data in Snowflake? (Choose two.)
Snowflake offers specific native data types designed to store semi-structured data effectively. These types are 'OBJECT' and 'VARIANT'. The 'OBJECT' type is used to store key-value pairs, making it suitable for JSON-like documents. On the other hand, the 'VARIANT' type is versatile and can store semi-structured data, including JSON, Avro, ORC, Parquet, and XML formats. Therefore, the correct answers are 'OBJECT' and 'VARIANT'.
Snowflake provides built-in support for importing data from (and exporting data to) the following semi-structured data formats: JSON Avro ORC Parquet XML Snowflake provides native data types (ARRAY, OBJECT, and VARIANT) for storing semi-structured data.
Correct