Exam SnowPro Core All QuestionsBrowse all questions from this exam
Go to Exam
Question 246

Which data types does Snowflake support when querying semi-structured data? (Choose two.)

    Correct Answer: A, D

    Snowflake supports the VARIANT and ARRAY data types when querying semi-structured data. The VARIANT type can store semi-structured data in formats like JSON, Avro, ORC, Parquet, and even XML and it allows the data to be queried directly. The ARRAY type is used to store arrays of VARIANT values, which is useful for data that is represented in an array format.

Discussion
AlexbDkuOptions: AD

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

halolOptions: AB

Variant and Array

halol

A,D Variant and Array

harshagc180Options: AD

Answer : Variant and Array https://docs.snowflake.com/en/user-guide/semistructured-intro.html#loading-semi-structured-data

Mallikharjuna452Options: AD

Variant and array

_yyuktaOptions: AD

A and D are correct

singhksOptions: AD

A and D are correct

MultiCloudIronManOptions: AD

Correct

pab1004Options: AD

A y D correct

miadieselOptions: AD

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

SnowProCertDec22Options: AD

d y a are correct