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

You need to identify which connectivity mode to use when implementing App2. The solution must support the planned changes and meet the business requirements.

Which connectivity mode should you identify?

You configure multi-region writes for account1.

You need to ensure that App1 supports the new configuration for account1. The solution must meet the business requirements and the product catalog requirements.

What should you do?

You are troubleshooting the current issues caused by the application updates.

Which action can address the application updates issue without affecting the functionality of the application?

You need to provide a solution for the Azure Functions notifications following updates to con-product. The solution must meet the business requirements and the product catalog requirements.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

You need to recommend indexes for con-product and con-productVendor. The solution must meet the product catalog requirements and the business requirements.

Which type of index should you recommend for each container? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You need to select the partition key for con-iot1. The solution must meet the IoT telemetry requirements.

What should you select?

You need to select the capacity mode and scale configuration for account2 to support the planned changes and meet the business requirements. What should you select? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

You need to implement a solution to meet the product catalog requirements.

What should you do to implement the conflict resolution policy.

You have an on-premises network.

You have an Azure subscription that contains an Azure Cosmos DB account named account1 and an Azure virtual network named VNet1. VNet1 contains two virtual machines named VM1 and VM2. VNet1 is connected to the on-premises network by using a Site-to-Site (S2S) VPN.

You need to meet the following requirements:

• Block access to the public endpoint of account1.

• Allow only VM1 to access account1.

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.

You need to create a database in an Azure Cosmos DB for NoSQL account. The database will contain three containers named coll1, coll2 and coll3. The coll1 container will have unpredictable read and write volumes. The col!2 and coll3 containers will have predictable read and write volumes. The expected maximum throughput for coll1 and coll2 is 50,000 request units per second (RU/s) each.

How should you provision the collection while minimizing costs?

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named accounts In account1, you create a container that has the following configurations:

• Partition key: CompanylD

• Composite unique key: UserName and EmailAddress

To the container, you plan to add the data items shown in the following table.

How many conflicts will occur?

You have an Azure Cosmos DB for NoSQL database that hosts a container named Container^

You are developing a new app named App1 that will use Container 1.

You need to ensure that when App1 attempts to delete a document in Container1, the action is blocked, and an error is returned to the app.

What should you use?

You have a container in an Azure Cosmos DB for NoSQL account that stores data about orders. The following is a sample of an order document.

Documents are up to 2 KB.

You plan to receive one million orders daily.

Customers will frequently view then past order history.

You are the evaluating whether to use orderDate as the partition key.

What are two effects of using orderDate as the partition key? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

You have a database named telemetry in an Azure Cosmos DB Core (SQL) API account that stores IoT data. The database contains two containers named readings and devices.

Documents in readings have the following structure.

id

deviceid

timestamp

ownerid

measures (array)

- type

- value

- metricid

Documents in devices have the following structure.

id

deviceid

owner

- ownerid

- emailaddress

- name

brand

model

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

You have an application that queries an Azure Cosmos 06 for NoSQL account.

You discover that the following two queries run frequently,

You need to minimize the request units (RUs) consumed by reads and writes. What should you create?

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named accounts In account1, you plan to create a container that will store the data items shown in the following table.

Each customer item will have customer sales by month values embedded.

The most executed query will return data for a matrix that aggregates the monthly sales ot each business category. The matrix will use customer business categories as columns and months as rows.

You need to configure the partition key for the container. The solution must minimize the request units (RUs) required to run the query.

Which property should you use for the partition key?

You have a database in an Azure Cosmos DB for NoSQL account that is configured for multi-region writes.

You need to use the Azure Cosmos DB SDK to implement the conflict resolution policy for a container. The solution must ensure that any conflict sent to the conflict feed.

Solution: You set ConfilictResolutionMode to Custom. You Set ResolutionProcedures to a custom stored procedure. You configure the custom stored procedure to use the isTomstone parameter to resolve conflict.

Does this meet the goal?

You have an Azure Cosmos DB for NoSQL container. The container contains items that have the following properties.

You need to protect the data stored in the container by using Always Encrypted. For each property, you must use the strongest type of encryption and ensure that queries execute properly.

What is the strongest type of encryption that you can apply to each property? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

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?

You are designing an Azure Cosmos DB Core (SQL) API solution to store data from IoT devices. Writes from the devices will be occur every second.

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?

You have the following Azure Resource Manager (ARM) template.

You plan to deploy the template in incremental mode.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

You have an Azure subscription.

You plan to implement an Azure Cosmos DB for NoSQL single-region write account named account1 that will replicate across two Azure regions.

You need to set the default consistency level for account1. The solution must meet the following requirements:

• Writes must be performed to a local majority in a single region.

• Reads must be performed from a local minority in a single region.

Which consistency level should you select?

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 result1 these questions will not appear in the review screen.

You have a database in an Azure Cosmos DB for NoSQL account that is configured for multi-region writes.

You need to use the Azure Cosmos OB SDK to implement the conflict resolution policy for a container. The solution must ensure that any conflicts are sent to the conflicts feed.

Solution: You set ConflictResolutionMode to Laswriterwins and you use the default settings for the policy.

Does this meet the goal?

You have a container in an Azure Cosmos DB Core (SQL) API account. The container stores telemetry data from IoT devices. The container uses telemetryId as the partition key and has a throughput of 1,000 request units per second (RU/s). Approximately 5,000 IoT devices submit data every five minutes by using the same telemetryId value.

You have an application that performs analytics on the data and frequently reads telemetry data for a single IoT device to perform trend analysis.

The following is a sample of a document in the container.

You need to reduce the amount of request units (RUs) consumed by the analytics application.

What should you do?

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

The following is a sample of a document in container1.

{

" studentId " : " 631282 " ,

" firstName " : " James " ,

" lastName " : " Smith " ,

" enrollmentYear " : 1990,

" isActivelyEnrolled " : true,

" address " : {

" street " : " " ,

" city " : " " ,

" stateProvince " : " " ,

" postal " : " " ,

}

}

The container1 container has the following indexing policy.

{

" indexingMode " : " consistent " ,

" includePaths " : [

{

" path " : " /* "

},

{

" path " : " /address/city/? "

}

],

" excludePaths " : [

{

" path " : " /address/* "

},

{

" path " : " /firstName/? "

}

]

}

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

You have an Azure Cosmos DB account named accounts

You need to access account1 from an on-premises environment by using a Site-to-Site VPN. What should you use?

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named account1.

Backups for account1 have the following configurations:

• Interval: 2 hours

• Retention period: 4 days

You need to estimate the charges associated with the retention of the backups. How many copies of the backups will incur additional charges?

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

You implement a change feed processor.

You discover that the processor is processing changes more slowly than the changes occur in Container1.

You need to resolve the issue.

What should you use?

You are implementing an Azure Data Factory data flow that will use an Azure Cosmos DB (SQL API) sink to write a dataset. The data flow will use 2,000 Apache Spark partitions.

You need to ensure that the ingestion from each Spark partition is balanced to optimize throughput.

Which sink setting should you configure?