nerdexam
Microsoft

DP-420 · Question #173

Drag and Drop Question You have an Azure Cosmos DB container named owners. Each item in owners represents an owner and their pets. The following is a sample of the JSON You are writing a query that wi

Sign in or unlock DP-420 to reveal the answer and full explanation for question #173. The question stem and answer options stay visible for context.

Optimize an Azure Cosmos DB solution

Question

Drag and Drop Question You have an Azure Cosmos DB container named owners. Each item in owners represents an owner and their pets. The following is a sample of the JSON You are writing a query that will retrieve the average age of each pet owned by each owner, if the pet is older than two years. How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Answer:

Exhibit

DP-420 question #173 exhibit

Answer Area

Drag items

ASCOUNTINJOINSUMVALUE

Unlock DP-420 to see the answer

You've previewed enough free DP-420 questions. Unlock DP-420 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Cosmos DB SQL API#Nested Array Querying#Aggregation Functions#GROUP BY
Full DP-420 Practice