SnowPro Core Certification — Question 789

How can a Snowflake user traverse semi-structured data?

Answer options

• A. Insert a colon (:) between the VARIANT column name and any first-level element.
• B. Insert a colon (:) between the VARIANT column name and any second-level element.
• C. Insert a double colon (::) between the VARIANT column name and any first-level element.
• D. Insert a double colon (::) between the VARIANT column name and any second-level element.

Correct answer: A

Explanation

The correct answer is A because using a colon (:) allows the user to access first-level elements directly within a VARIANT column. Options B, C, and D are incorrect as they either reference the wrong level of elements or use the wrong notation for accessing first-level elements.