Answer-first summary for fast verification
Answer: The column name is case-insensitive but element names are case-sensitive.
The correct answer is D because in Snowflake, when traversing semi-structured data, column names are case-insensitive while element names (path expressions) are case-sensitive. This is confirmed by the community discussion where multiple users with upvotes support answer D, with one user providing a clear example showing that 'src:salesperson.name' and 'SRC:salesperson.name' are equivalent (demonstrating column name case-insensitivity), but 'SRC:Salesperson.Name' is different (demonstrating element name case-sensitivity). The official Snowflake documentation link provided in the discussion also supports this behavior.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What are the considerations for writing the column name and path expressions for element names when traversing semi-structured data?
A
The column name and element names are both case-sensitive.
B
The column name and element names are both case-insensitive.
C
The column name is case-sensitive but element names are case-insensitive.
D
The column name is case-insensitive but element names are case-sensitive.
No comments yet.