SnowPro Core Certification — Question 1309

Which JSON paths are considered to be equivalent in Snowflake? (Choose two.)

Answer options

• A. src['customer']['EMAIL']
• B. src['CUSTOMER']['Email']
• C. SRC:Customer.Email
• D. src:customer.email
• E. SRC:customer.email

Correct answer: D, E

Explanation

The correct answers, D and E, are both using the case-insensitive notation for JSON paths in Snowflake, where 'src:customer.email' and 'SRC:customer.email' are treated as equivalent. Options A, B, and C have different casing and formats that do not align with Snowflake's JSON path equivalency rules.