What are the native data types that Snowflake provides to store semi-structured data? (Choose two.)
What are the native data types that Snowflake provides to store semi-structured data? (Choose two.)
Snowflake provides native data types specifically designed for storing semi-structured data. These include the ARRAY and VARIANT data types. ARRAY is used to store arrays, which are ordered lists of values. VARIANT is a flexible data type that can store values of various types, including objects and arrays, making it well-suited for semi-structured data such as JSON documents. Note that JSON, ORC, and Parquet mentioned in the options are data formats rather than data types.
The question is about data type not file type
Correct
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.