Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Go to Exam

Question 691

How can a Snowflake user access a JSON object, given the following table? (Choose two.)

src:salesperson.name

src:salesPerson.name

src:salesPerson.Name

SRC:salesPerson.name

SRC:salesPerson.Name

Correct Answer: B, D

To access a JSON object in Snowflake, the column name is case-insensitive while the element names are case-sensitive. Given the table, accessing 'name' within 'salesPerson' can be done using 'src:salesPerson.name' or 'SRC:salesPerson.name'. Therefore, the correct options are 'src:salesPerson.name' and 'SRC:salesPerson.name'.

Discussion

ravuri_rkOptions: BD

https://docs.snowflake.com/en/user-guide/querying-semistructured Important Regardless of which notation you use, the column name is case-insensitive but element names are case-sensitive. For example, in the following list, the first two paths are equivalent, but the third is not: src:salesperson.name SRC:salesperson.name SRC:Salesperson.Name

MultiCloudIronManOptions: BD

correct

Snow_POptions: AB

A is one of the correct

Snow_P

Agree with Ravuri, B&D