Explanation:
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.
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.