SnowPro Core Certification — Question 965

What are the correct settings for column and element names, regardless of which notation is used while accessing elements in a JSON object?

Answer options

• A. Both the column name and the element name are case-insensitive.
• B. Both the column name and the element name are case-sensitive.
• C. The column name is case-sensitive and the element names are case-insensitive.
• D. The column name is case-insensitive and the element name is case-sensitive.

Correct answer: D

Explanation

The correct answer is D because in JSON, column names (keys) are typically case-insensitive when referenced in most databases, while element names (keys in JSON objects) are case-sensitive. The other options incorrectly represent the sensitivity of either the column or element names.