DP-420 Practice Questions

You plan to create an operational system that will store data in an Azure Cosmos OB ' or NoSQL account. You need to configure the account to meet the following requirements:

• Support Spark queries.

• Support the analysis of data from the last six months.

• Only pay for analytical compute when running queries.

Which three actions should you perform? Each correct answer presents part of the solution. NOTE Each correct selection is worth one point.

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 uses the default consistency level. How can the consistency level be modified as part of a query request?

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 have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named account1 and a Log Analytics workspace named Workspace1. Workspace 1 stores the logs of account1.

You need to identify which operations used the most request units per second (RU/s) during the last 24 hours.

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 have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named account1.

For account 1, you plan to implement an integrated gateway that will use the D4s SKU.

You need to optimize integrated gateway performance for point reads from account1. The solution must meet the following requirements:

• For new point reads, maximize how long returned items remain in the integrated cache.

• For new and repeating point reads, maximize the cost benefits of the integrated cache.

What should you do for each requirement? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have an Azure Cosmos DB Core (SQL) API account named account1.

In account1, you run the following query in a container that contains 100GB of data.

SELECT *

FROM c

WHERE LOWER(c.categoryid) = " hockey "

You view the following metrics while performing the query.

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 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 K

B.  

You plan to receive one million orders daily.

Customers will frequently view their past order history.

You are the evaluating whether to use order-Date as the partition key.

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

NOTE: Each correct selection is worth one point.

You have an Azure subscription that contains the resources shown in the following table.

In CosmosDB1, you plan to create a container named Container1 that will store sensitive data.

You need to ensure that Container1 uses Always Encrypted for Azure Cosmos D

B.  

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

You have a container named container1 in an Azure Cosmos DB for NoSQL account named account1 that is set to the session default consistency level. The average size of an item in container1 is 20 K

B.  

You have an application named App1 that uses the Azure Cosmos DB SDK and performs a point read on the same set of items in container1 every minute.

You need to minimize the consumption of the request units (RUs) associated to the reads by App1. What should you do?