Microsoft DP-420 Actual Free Exam Questions & Community Discussion

You are designing an Azure Cosmos DB for NoSQL solution to store data from IoT devices.
Writes from the devices will occur every second. Data will be retained indefinitely.
The following is a sample of the data.

You need to select a partition key that meets the following requirements for writes:
- Minimizes the partition skew
- Avoids capacity limits
- Avoids hot partitions
What should you do?

Hotspot Question
You have an Azure Cosmos DB for NoSQL database named db1.
You run the following code:

For each of the following statements, select Yes if the statements true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

You have a container named container1 in an Azure Cosmos DB for NoSQL account. Upserts of items in container1 occur every three seconds.
You have an Azure Functions app named function1 that is supposed to run whenever items are inserted or replaced in container1.
You discover that function1 runs, but not on every upsert.
You need to ensure that function1 processes each upsert within one second of the upsert.
Which property should you change in the Function.json file of function1?

You have an Azure Cosmos DB for NoSQL account that contains a database and a container named Container1. You plan to develop a new app named App1 that will store entities in Container1. App1 will have the following versioning requirements for the entities:
- Each entity must be associated with multiple document versions.
- Each document version must be associated with one entity.
You need to recommend a versioning model for App1. The solution must minimize development and operational effort.
What should you recommend?

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named account1.
You plan to configure the Apache Kafka service as a data source for account1.
What should you use to store the Kafka configuration?

Your company develops an application named App1 that uses the Azure Cosmos DB SDK and the Eventual consistency level.
App1 queries an Azure Cosmos DB for NoSQL account named account1.
You need to identify which consistency level to assign to App1 to meet the following requirements:
- Maximize the throughput of the queries generated by App1 without
increasing the number of request units currently used by the queries.
- Provide the highest consistency guarantees.
Which consistency level should you identify?

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 Data Factory pipeline that uses Azure Cosmos DB for NoSQL as the input and Azure Blob Storage as the output.
Does this meet the goal?

Hotspot Question
You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account. The account hosts a container named Container1 that stores customer data. Each customer data item includes the customer's name and zero or more related business categories in an array.
You need identify customers that have one of their business categories set to "retail". The solution must return the customerName and businessCategories fields.
How should you complete the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

You provision an Azure Cosmos DB for NoSQL container. You set the throughput to Autoscale, and the maximum request units per second (RU/s) to 20,000.
For how many RU/s will you be charged when the actual RU/s usage is zero?

You have an Azure Cosmos DB database named database1 that contains a container named container1. The container1 container stores product data and has the following indexing policy.
Which path will be indexed?

Hotspot Question
You have an Azure Cosmos DB account named account1 that has a default consistency level of session.
You have an app named App1.
You need to ensure that the read operations of App1 can request either bounded staleness or consistent prefix consistency.
What should you modify for each consistency level? To answer, select the appropriate options in the answer area.

Hotspot Question
You have an Azure Cosmos DB for NoSQL account.
You plan to create a container named container1. The container1 container will store items that include two properties named name and age.
The most commonly executed queries will query container1 for a specific name. The following is a sample of the query.

You need to define an opt-in indexing policy for container1. The solution must meet the following requirements:
- Minimize the number of request units consumed by the queries.
- Ensure that the _etag property is excluded from indexing.
How should you define the indexing policy? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.