SnowPro Advanced: Architect — Question 141

A table, contacts_data, is created and data is inserted into it:

create table contacts_data (c object);

Insert into contacts_data -
select parse_json ('
{
"customer”: {
"address": "509 Kings Hwy, Comptche, Missouri, 4848",
"phone": "+1 (999) 407-2274",
"email": "[email protected]",
"company": "SNOWFLAKE",
"name": {
"last": "Person",
"first": "Snow"
},
"_id": "5730864df388fld653e37e6f"
}
}
');

Which queries will retrieve the first name value as Snow? (Choose two.)

Answer options

• A. select o[customer][name][first]::string as first_name from contacts_data;
• B. select o['customer']['name']['first']::string as first_name from contacts_data;
• C. select o:['customer']:['name']:['first']::string as first_name from contacts_data;
• D. select 0:Customer.Name.First::string as first_name from contacts_data;
• E. select 0:customer.name.first::string as first_name from contacts_data;

Correct answer: B, E

Explanation

The correct queries are B and E because they use the correct syntax to access nested JSON objects. Option A is incorrect due to the use of brackets instead of quotes for keys, while C uses invalid syntax with colons. Option D incorrectly capitalizes 'Customer' which does not match the JSON structure.