Which data types are supported by Snowflake when using semi-structured data? (Choose two.)
Which data types are supported by Snowflake when using semi-structured data? (Choose two.)
Snowflake supports several data types for handling semi-structured data. Among the given options, VARIANT and ARRAY are used to store semi-structured data such as JSON, Avro, ORC, Parquet, and XML. VARIANT allows for storing heterogeneous data types, accommodating semi-structured formats, while ARRAY is specifically used for handling ordered lists of elements. Therefore, these two types are the correct choices.
From documentation: https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html Variant, Object, Array - so of the available options in question. A and D.
Variant, Array and Object types.
Was on exam Dec 31st 2022
https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html
Array,Variant
Correct Answer: AD
A and D are correct
variant , array
Correct
Variant Object Array https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html