SnowPro Core Exam - Question 188

Question

Which data types are supported by Snowflake when using semi-structured data? (Choose two. ).

Examice · Accepted Answer

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.

halol · Answer

https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html

SV1122 · Answer

Was on exam Dec 31st 2022

alanhuangjob · Answer

Variant, Array and Object types.

lukalooko · Answer

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.

SV1122 · Answer

Variant
Object
Array
https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html

MultiCloudIronMan · Answer

Correct

Marge23 · Answer

variant , array

_yyukta · Answer

A and D are correct

AnireddySaikiranReddy · Answer

Correct Answer: AD

Mallikharjuna452 · Answer

Array,Variant

SnowPro Core Exam - Question 188

Discussion