
Answer-first summary for fast verification
Answer: src:customer.email, SRC:customer.email
In Snowflake, JSON path expressions are case-insensitive for object names but case-sensitive for element keys. Options D (src:customer.email) and E (SRC:customer.email) are equivalent because the object name 'src' and 'SRC' are treated the same (case-insensitive), and both use lowercase 'customer.email' for the element key, which matches exactly. Option A and B are incorrect because they use different cases for the element key ('EMAIL' vs 'Email'), making them not equivalent. Option C is incorrect as it uses uppercase 'Customer.Email' for the element key, which does not match the lowercase 'customer.email' in D and E. The community discussion, with 100% consensus and upvoted comments, confirms that D and E are equivalent due to case sensitivity rules for element keys.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.