Free Microsoft DP-420 Exam Questions

Become Microsoft Certified with updated DP-420 exam questions and correct answers

Page: 1 / 59

Total 291 Questions | Updated On: Jul 29, 2025

Add To Cart

Question 1

One of the team members has recently joined the team and wants to manually adjust the time for which the items will remain in the cache. He asks you for help about which property from the ItemRequestOptions class should he configure. What would you suggest?

A : ConsistencyLevel

B : SessionToken

C : MaxIntegratedCacheStalenessright

D : None of these

Answer: C

Question 2

You are working on an app that will save the device metrics produced every minute by various IoT devices. You decide to collect the data for two entities; the devices and the device metrics produced by each device. You were about to create two containers for these identified entities but suddenly your data engineer suggests you place both entities in a single container, not two different containers. You would like to be able to track the general data of the device and the number of metrics collections per device. How could we keep track of these entities inside the container?

A : Add a new property to your device documents called metricscollectioncount and update it with the current number of metrics collection documents. Subtract 1 from the metricscollectioncount property when your app or Azure function adds a new metrics collection

B : Add a new property to your device documents called metricscollectioncount and update it with the current number of metrics collection documents. Add 1 to the metricscollectioncount property inside a transactional batch when your app or Azure function adds a new metrics collectionright

C : Use a GROUP BY parameter in your query and use the aggregate count to return the number of device metrics collections per device

D : Use a GROUP BY parameter in your query and use the aggregate sum to return the number of device metrics collections per device

Answer: B

Question 3

You have an Azure Cosmos DB for NoSQL account that has multiple write regions. You need to receive an alert when requests that target the database exceed the available request units per second (RU/s). Which Azure Monitor signal should you use?

A : gion Removed

B : cument Quota

C : tadata Requests

D : ta Usage

Answer: B

Question 4

Note: This question is part of a series of questions that present the same scenario. Each question in the series

contains a unique solution that might meet the stated goals. Some question sets might have more than one

correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions

will not appear in the review screen.

You have a container named container1 in an Azure Cosmos DB Core (SQL) API account.

You need to make the contents of container1 available as reference data for an Azure Stream Analytics job.

Solution: You create an Azure Synapse pipeline that uses Azure Cosmos DB Core (SQL) API as the input and

Azure Blob Storage as the output.

Does this meet the goal?

A :

B :

Answer: B

Question 5

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 :

Answer: B,D

Page: 1 / 59

Total 291 Questions | Updated On: Jul 29, 2025

Add To Cart