Free Microsoft DP-420 Exam Dumps Questions & Answers

Hotspot Question
You have an Azure Cosmos DB for NoSQL account that hosts the containers shown in the following table.

You need to implement a solution for processing changes to author names. The solution must use a change feed and an Azure Function and must meet the following requirements:
- Ensure that when a name change occurs, the authorName field in the
Books container is updated within 30 minutes.
- Minimize costs.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Hotspot Question
You plan to create an Azure Cosmos DB database named db1 that will contain two containers.
One of the containers will contain blog posts, and the other will contain users. Each item in the blog post container will include:
- A single blog post
- All the comments associated to the blog post
- The names of the users who created the blog post and added the
comments
You need to design a solution to update usernames in the user container without causing data integrity issues. The solution must minimize administrative and development effort.
What should you include in the solution? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

You work in the Intel company that has its clients across 4 different countries, with hundreds of thousands of clients for countries 1 and 2, and a few thousand clients for countries 3 and 4.
Requests for every country total approximately 50,000 RU/s every hour of the day. The application team of the company suggests using countryId as the partition key for this container.
Which of the following statements is true?

• A.  All the above
• B.  This partition key could cause storage hot partitions
• C.  This partition key will cause fan out when filtering by countryId
• D.  This partition key will prevent throughput hot partitions

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.

Correct Answer:

Explanation:
Consistency can only be relaxed at the SDK instance or request level. To move from weaker to stronger consistency, update the default consistency for the Azure Cosmos DB account.
https://learn.microsoft.com/en-us/azure/cosmos-db/nosql/how-to-manage-consistency?tabs=portal%2Cdotnetv2%2Capi-async

The following is a sample of a document in orders.

The orders container uses customerId as the partition key.
You need to provide a report of the total items ordered per month by item type. The solution must meet the following requirements:
- Ensure that the report can run as quickly as possible.
- Minimize the consumption of request units (RUs).
What should you do?

• A.  Configure the report to query a new materialized view. Populate the view by using SQL queries that run daily.
• B.  Configure the report to query a new materialized view. Populate the view by using the change feed.
• C.  Configure the report to query orders by using a SQL query through a dedicated gateway.
• D.  Configure the report to query orders by using a SQL query.