Independence Day Deal! Unlock 25% OFF Today – Limited-Time Offer - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam DP-420 Topic 14 Question 36 Discussion

Actual exam question for Microsoft's DP-420 exam
Question #: 36
Topic #: 14
[All DP-420 Questions]

You are developing an application that will use an Azure Cosmos DB Core (SQL) API account as a data source.

You need to create a report that displays the top five most ordered fruits as shown in the following table.

A collection that contains aggregated data already exists. The following is a sample document:

{

"name": "apple",

"type": ["fruit", "exotic"],

"orders": 10000

}

Which two queries can you use to retrieve data for the report? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

A)

B)

C)

D)

Show Suggested Answer Hide Answer
Suggested Answer: A

Contribute your Thoughts:

Osvaldo
1 months ago
Option B is the way to go, my friends. It's like ordering a classic cheeseburger - no need for fancy toppings when the core ingredients are perfect.
upvoted 0 times
...
Arletta
1 months ago
Ah, the age-old dilemma of too many options. But in this case, Option B stands out as the clear winner. It's like choosing the ripe, juicy apple over the exotic, overly complicated fruit.
upvoted 0 times
...
Ivan
1 months ago
Hmm, Option D seems a bit too complex for this use case. I'm leaning towards Option B - it gets the job done without any unnecessary frills.
upvoted 0 times
Amie
9 days ago
I think Option B is the way to go for simplicity and effectiveness.
upvoted 0 times
...
Ben
19 days ago
Yeah, Option B seems like the most efficient choice here.
upvoted 0 times
...
Daniel
21 days ago
I agree, Option B looks like the most straightforward solution for this report.
upvoted 0 times
...
...
Mozell
2 months ago
While Option A might work, it seems a bit overkill for this simple requirement. I'd go with Option B to keep things clean and efficient.
upvoted 0 times
...
Wei
2 months ago
The query in Option B looks like the perfect solution to retrieve the top 5 most ordered fruits. It's simple, straightforward, and clearly accomplishes the task at hand.
upvoted 0 times
Maryann
11 days ago
Let's go with Option B for the query, it looks like the most efficient solution.
upvoted 0 times
...
Tess
13 days ago
I think Option B will make it easy to get the top 5 most ordered fruits without any complications.
upvoted 0 times
...
Lauran
15 days ago
I agree, Option B seems like the best choice for retrieving the data we need.
upvoted 0 times
...
...
Fausto
2 months ago
I'm not sure, I think Option C could also work well for this scenario.
upvoted 0 times
...
Louisa
2 months ago
I agree with Merri, Option A seems like the best solution for the report.
upvoted 0 times
...
Merri
2 months ago
I think we should use Option A to retrieve the data.
upvoted 0 times
...

Save Cancel
az-700  pass4success  az-104  200-301  200-201  cissp  350-401  350-201  350-501  350-601  350-801  350-901  az-720  az-305  pl-300  

Warning: Cannot modify header information - headers already sent by (output started at /pass.php:70) in /pass.php on line 77