Free Practice Questions for Microsoft DP-420 Exam

You have an Azure Cosmos DB for NoSQL account that uses a custom conflict resolution policy. The account has a registered merge procedure that throws a runtime exception. The runtime exception prevents conflicts from being resolved.

You need to use an Azure function to resolve the conflicts. What should you use?

You have a development environment that uses multiple Azure subscriptions.

You plan to deploy a single Azure Cosmos DB account that will contain a single database in each subscription.

You need to automate the deployment by using an Azure Resource Manager (ARM) template. The solution must meet the following requirements:

• Minimize Azure Cosmos DB-related charges.

• Maximize the available request units per second (RU/s) without increasing costs.

How should you complete the template? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

You have an Azure Cosmos OB for NoSQL account configured for global distribution across four regions. At connection time, the SQL SDK needs to identify the optimal endpoint for reading and writing. Which two factors can influence the SDK? Each correct answer presents a complete solution NOTE- Each correct selection is worth one point.

You plan to implement an Azure Cosmos DB container that will store telemetry data from 1,000 loT devices. The data will be updated once every minute. An app will read the data once daily and generate aggregated reports that summarize the state of each device.

You need to configure a partition key for the container. The solution must meet the following requirements:

• Minimize the possibility of reaching the partition limits.

• Spread read and write operations evenly across the partitions.

• Minimize how long it takes to locate a specific set of telemetry values.

To what should you set the partition key?

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?

You have an Azure Cosmos DB for NoSQL database named DB1 that hosts a container named Container1. The partition key for Container 1 is /pki.

You have a .NET app that connects to DBi.

You need to retrieve the request unit (RU) cost of a point operation and store the value as a variable.

How should you complete the C# code? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You need to create a data store for a directory of small and medium-sized businesses (SMBs). The data store must meet the following requirements:

* Store companies and the users employed by them. Each company will have less than 1,000 users.

* Some users have data that is greater than 2 KB.

* Associate each user to only one company.

* Provide the ability to browse by company.

* Provide the ability to browse the users by company.

* Whenever a company or user profile is selected, show a details page for the company and all the related users.

* Be optimized for reading data.

Which design should you implement to optimize the data store for reading data?

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL database named DB1.

You develop a software as a service (SaaS) app named App1 that uses DB1. App1 will be used by multiple vendors to manage their customers.

You need to create a container in DB1 that will store customer and order details for each vendor. The solution must meet the following requirements:

• Each vendor must have a unique tenant ID.

• The performance of the container must be optimized for reads.

• Customer IDs can be duplicated across the container but must be unique for each vendor.

• The container must be optimized for concurrent queries from multiple customers. Each query will return data for a single vendor.

How should you configure the container?

You have an Azure Cosmos DB for NoSQL account that contains a container named Container1.

You add a composite index to the default indexing policy of Container1. The index has the following definition.

FirstName ASC, age ASC

You plan to execute the following query against Container1.

You need to optimize the performance of the query by adding an additional index.

How should you complete the additional index? To answer, select the appropriate options in the answer area

NOTE: Each correct selection is worth one point.