Welcome to TestSimulate

Pass Your Next Certification Exam Fast!

Everything you need to prepare, learn & pass your certification exam easily.

365 days free updates. First attempt guaranteed success.

Microsoft Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB (DP-420) Free Practice Test

Question 1
Hotspot Question
You have an Azure subscription.
You need to deploy the following resources to an Azure Cosmos DB for NoSQL account:
- A container
- A user-defined function (UDF)
The solution must minimize the possibility of the deployment failing.
How should you complete the template? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:
Question 2
You have an Azure Cosmos DB for NoSQL account named account1.
You have an app named App1 that connects to account1 and uses strong consistency for all requests.
You implement the Azure Cosmos DB integrated cache for account1.
You need to ensure that App1 uses the integrated cache.
What should you do?

Correct Answer: C
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 3
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:
Question 4
Hotspot Question
You have an Azure Cosmos DB for NoSQL database that hosts a container named Container1.
Container1 stores order details, including the following properties:
- OrderNumber (a number)
- OrderDate (a date)
You need to write a query that returns the following for each order:
- OrderNumber
- PeriodDate (as the first day of the calendar year based on orderDate) How should you complete the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point
Correct Answer:
Question 5
You have an Azure Cosmos DB for NoSQL database named db1 that writes to multiple Azure regions.
You need to test the performance of db1 in the secondary region.
Which command should you run first?

Correct Answer: D
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 6
You develop an application that uses Azure Cosmos DB Core (SQL) API.
You create an Azure pipeline to build and deploy the application.
You need to change the pipeline to run integration tests that you wrote for the application. The solution must execute entirely in the pipeline.
What should you add to the pipeline?

Correct Answer: A
Question 7
You have a container in an Azure Cosmos DB for NoSQL account.
You need to create an alert based on a custom Log Analytics query.
Which signal type should you use?

Correct Answer: B
Question 8
Case Study 1 - Litware, inc
Overview
Litware, Inc. is a United States-based grocery retailer. Litware has a main office and a primary datacenter in Seattle. The company has 50 retail stores across the United States and an emerging online presence. Each store connects directly to the internet. Existing environment.
Cloud and Data Service Environments. Litware has an Azure subscription that contains the resources shown in the following table.

Each container in productdb is configured for manual throughput. The con-product container stores the company's product catalog data. Each document in con-product includes a con- productvendor value. Most queries targeting the data in con-product are in the following format.
SELECT * FROM con-product p WHERE p.con-productVendor - 'name'
Most queries targeting the data in the con-productVendor container are in the following format SELECT * FROM con-productVendor pv ORDER BY pv.creditRating, pv.yearFounded Existing environment.
Current Problems.
Litware identifies the following issues:
- Updates to product categories in the con-productVendor container do not propagate automatically to documents in the con-product container.
- Application updates in con-product frequently cause HTTP status code 429 "Too many requests".
- You discover that the 429 status code relates to excessive request unit (RU) consumption during the updates.
Requirements.
Planned Changes
Litware plans to implement a new Azure Cosmos DB for NoSQL account named account2 that will contain a database named iotdb. The iotdb database will contain two containers named con- iot1 and con-iot2.
Litware plans to make the following changes:
- Store the telemetry data in account2.
- Configure account1 to support multiple read-write regions.
- Implement referential integrity for the con-product container.
- Use Azure Functions to send notifications about product updates to different recipients.
- Develop an app named App1 that will run from all locations and query the data in account1.
- Develop an app named App2 that will run from the retail stores and query the data in account2.
- App2 must be limited to a single DNS endpoint when accessing account2.
Requirements.
Business Requirements
Litware identifies the following business requirements:
- Whenever there are multiple solutions for a requirement, select the solution that provides the best performance, as long as there are no additional costs associated.
- Ensure that Azure Cosmos DB costs for IoT-related processing are predictable.
- Minimize the number of firewall changes in the retail stores.
Requirements.
Product Catalog Requirements
Litware identifies the following requirements for the product catalog:
- Implement a custom conflict resolution policy for the product catalog data.
- Minimize the frequency of errors during updates of the con-product container.
- Once multi-region writes are configured, maximize the performance of App1 queries against the data in account1.
- Trigger the execution of two Azure functions following every update to any document in the con- product container.
Hotspot Question
You plan to implement con-iot1 and con-iot2.
You need to configure the default Time to Live setting for each container. The solution must meet the IoT telemetry requirements.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:

Explanation:
Box 1: On (3,600 seconds)
Note: Litware identifies the following IoT telemetry requirements:
Automatically delete items in con-iot1 after one hour unless a per-item time to live is set.
Box 2: Off
Ensure that the items in con-iot2 persist regardless of the per-item time to live setting.
Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/sql/time-to-live
Question 9
You have an Azure Cosmos DB Core (SQL) API account named account1 that is configured for automatic failover. The account1 account has a single read-write region in West US and a read region in East US.
You run the following PowerShell command.
Update-AzCosmosDBAccountFailoverPriority -ResourceGroupName `rg1` -Name
`account1` -FailoverPolicy @(`East US`, `West US`)
What is the effect of running the command?

Correct Answer: D
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).