SnowPro Core Exam QuestionsBrowse all questions from this exam

SnowPro Core Exam - Question 246


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

Show Answer
Correct Answer: AD

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

10 comments
Sign in to comment
AlexbDkuOptions: AD
Dec 23, 2022

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

harshagc180Options: AD
Dec 8, 2022

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

halolOptions: AB
Dec 8, 2022

Variant and Array

halol
Dec 8, 2022

A,D Variant and Array

SnowProCertDec22Options: AD
Dec 15, 2022

d y a are correct

miadieselOptions: AD
Dec 22, 2022

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

pab1004Options: AD
Mar 23, 2023

A y D correct

MultiCloudIronManOptions: AD
Jul 20, 2023

Correct

singhksOptions: AD
Aug 19, 2023

A and D are correct

_yyuktaOptions: AD
Feb 26, 2024

A and D are correct

Mallikharjuna452Options: AD
Jul 22, 2024

Variant and array