Exam AZ-204 topic 9 question 2 discussion

goodluck!

The last one should be o.address.city

Got this in exam today..20/02/23

This question is probably part of Case study Coho Winery

Now let's review all questions again because there are dozens of them lol

I passed with only these questions, so don't stress guys. 80% of these questions is exactly the same. Good luck!

I got this question and json had address node inside main json. So answer would be o. address.city

HOPE NOT TO SEE YOU AGAIN

I suspect that the JSON document is incomplete. But if the city were going to be anywhere it would be in the Order, not the line. So the last answer is either o.city or o.address.city. For that we have to guess because there's way to tell if the address information is stored inline in the order or in a class called address. It could be either of: "street": "828 Broadway", "city": "New York" or "address": { "street": "828 Broadway", "city": "New York" }

Where is the city field in json???

https://docs.microsoft.com/ja-jp/azure/cosmos-db/sql-query-getting-started#query-the-json-items

where is the city field in order?