AZ-204 Quiz

Cosmos DB

Question:

Given the following data:

[
	{
		"id": "6e9f51c1-6b45-440f-af5a-2abc96cd083d",
		"categoryName": "Sleeping Bags",
		"name": "Vareno Sleeping Bag (6') Turmeric",
		"price": 120,
		"closeout": true,
		"manufacturer": {
			"name": "Vareno"
		},
		"tags": [{ "name": "Color Group: Yellow" }, { "name": "Bag Shape: Mummy" }]
	}
]

Write a query that will return this result, filtering by teapo-surfboard-72109:

[
	{
		"name": "Teapo Surfboard (6'10\") Grape",
		"sku": "teapo-surfboard-72109",
		"vendor": "Taepo"
	}
]

-- Code here

Answer:

SELECT VALUE {
  "name": p.name,
  "sku": p.sku,
  "vendor": p.manufacturer.name
}
FROM products p
WHERE p.sku = "teapo-surfboard-72109"

Report a problem

Exam revision: April 11, 2025