Exam DP-420 topic 1 question 3 discussion

Actual exam question from Microsoft's DP-420

Question #: 3
Topic #: 1

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:

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

Suggested Answer: BD
ARRAY_CONTAINS returns a Boolean indicating whether the array contains the specified value. You can check for a partial or full match of an object by using a boolean expression within the command.
Incorrect Answers:
A: Default sorting ordering is Ascending. Must use Descending order.
C: Order on Orders not on Type.
Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/sql/sql-query-array-contains

by itsmenida1 at Dec. 24, 2022, 2:34 p.m.

Comments

Submit Cancel

itsmenida1

Highly Voted 1 year, 10 months ago

correct

upvoted 6 times

...

[Removed]

Most Recent 8 months, 1 week ago

BD, these are the queries that have the correct ORDER BY

upvoted 1 times

...

dudud

1 year, 1 month ago

I think that on top in the grid with data there should be Types and not just Type since in all queries use .types

upvoted 1 times

...

virgilpza

1 year, 8 months ago

answer is correct

upvoted 3 times

...

Exam DP-420 All Questions

View all questions & answers for the DP-420 exam