SnowPro Advanced: Data Engineer — Question 105

When working with semi-structured data in a VARIANT column, which Snowflake functions will allow a user to write queries that extract values using a hierarchy name? (Choose two.)

Answer options

• A. GET()
• B. PARSE_JSON()
• C. GET_PATH()
• D. LATERAL FLATTEN
• E. TO_ARRAY()

Correct answer: A, C

Explanation

The GET() and GET_PATH() functions are specifically designed to extract values from semi-structured data in a VARIANT column using a given hierarchy. The other options, such as PARSE_JSON(), LATERAL FLATTEN, and TO_ARRAY(), do not directly provide the same hierarchical extraction capabilities.