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",
		"sku": "vareno-sleeping-bag-72109",
		"price": 120,
		"closeout": true,
		"manufacturer": {
			"name": "Vareno"
		},
		"tags": [{ "name": "Color Group: Yellow" }, { "name": "Bag Shape: Mummy" }]
	},
	{
		"id": "12345",
		"categoryName": "Surfboards",
		"name": "Teapo Surfboard (6'10\") Grape",
		"sku": "teapo-surfboard-72109",
		"price": 500,
		"closeout": false,
		"manufacturer": {
			"name": "Taepo"
		},
		"tags": [{ "name": "Color Group: Purple" }]
	}
]


What result this query will produce:

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


[
	// Result here
]


Report a problem
Exam revision: April 11, 2025