Valid DP-420 Dumps shared by ExamDiscuss.com for Helping Passing DP-420 Exam! ExamDiscuss.com now offer the newest DP-420 exam dumps, the ExamDiscuss.com DP-420 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com DP-420 dumps with Test Engine here:
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)
Correct Answer: B,D
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.