Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Go to Exam

Question 817

How can a Snowflake user traverse semi-structured data?

Insert a colon (:) between the VARIANT column name and any first-level element.

Insert a colon (:) between the VARIANT column name and any second-level element.

Insert a double colon (::) between the VARIANT column name and any first-level element.

Insert a double colon (::) between the VARIANT column name and any second-level element.

Correct Answer: A

A Snowflake user can traverse semi-structured data by inserting a colon (:) between the VARIANT column name and any first-level element. This syntax allows users to navigate and query nested data structures efficiently.

Discussion

kayuhanbidukOption: A

A : select column:first_level_column from json_table

HeetecOption: A

A correct - https://community.snowflake.com/s/article/querying-semi-structured-data#:~:text=Snowflake%20supports%20SQL%20queries%20that%20access%20semi-structured%20data,as%20the%20path%20delimiter%2C%20i.e.%20the%20form%20table.column%3Apathelement1.pathelement2.pathelement3.