Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB v1.0

You have an Azure Cosmos DB database.

You plan to create a new container named container1 that will store product data and product category data and will primarily support read requests.

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

• Minimize the size of the partition.
• Minimize maintenance effort.

Which two characteristics should you prioritize? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

HOTSPOT
-

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.

DRAG DROP
-

You are designing three apps named App1, App2, and App3. Each app will use a separate Azure Cosmos DB for NoSQL account. The apps have the following consistency requirements:
• App1: Reads must always return the most recent committed version of an item, where the commit occurred during the same session.
• App2: Reads must always return the most recent committed version of an item, even if the commit occurred during another session.
• App3: Write latency must be minimized and data staleness can be tolerated.

You need to recommend a default consistency level for each Azure Cosmos DB for NoSQL account. The solution must minimize concurrency.

What should you recommend for the account of each app? To answer, drag the appropriate consistency levels to the correct apps. Each consistency level may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

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

You need to create a container named Container1 in account1 by using the Azure Cosmos DB .NET SDK. The solution must ensure that the items in Container1 never expire.

What should you set?

You are designing an Azure Cosmos DB for NoSQL solution to store data from IoT devices. Writes from the devices will occur every second. Data will be retained indefinitely.

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?

HOTSPOT
-

You have an Azure Cosmos DB for NoSQL container named Contacts that is configured as shown in the following exhibit.



Contacts contains the items shown in the following table.



To Contacts, you plan to Insert the items shown in the following table.



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

NOTE: Each correct selection is worth one point.

HOTSPOT
-

You plan to create an Azure Cosmos DB container named account that will contain items in the following format.



You need to define a query that will return the ids of all accounts that have ever recorded a negative value for balance.

How should you complete the query? To answer select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

HOTSPOT
-

You have the Azure Cosmos DB for NoSQL containers shown in the following table.



You have the items shown in the following table.



When will each item expire? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Your company develops an application named App1 that uses the Azure Cosmos DB SDK and the Eventual consistency level.

App1 queries an Azure Cosmos DB for NoSQL account named account1.

You need to identify which consistency level to assign to App1 to meet the following requirements:

• Maximize the throughput of the queries generated by App1 without increasing the number of request units currently used by the queries.
• Provide the highest consistency guarantees.

Which consistency level should you identify?

HOTSPOT
-

You plan to create an Azure Cosmos DB for NoSQL container that will contain items in the following format.



You need to define a query that will return the userid values of all the users who purchased an item that has a sku value of 11111.

How should you compete the query? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

HOTSPOT
-

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named account1 and a Log Analytics workspace named Workspace1. Workspace1 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 provision an Azure Cosmos DB for NoSQL container. You set the throughput to Autoscale, and the maximum request units per second (RU/s) to 20,000.

For how many RU/s will you be charged when the actual RU/s usage is zero?

DRAG DROP -
You have an Azure Cosmos DB Core (SQL) API account that is configured for multi-region writes. The account contains a database that has two containers named container1 and container2.
The following is a sample of a document in container1:
{
"customerId": 1234,
"firstName": "John",
"lastName": "Smith",
"policyYear": 2021
}
The following is a sample of a document in container2:
{
"gpsId": 1234,
"latitude": 38.8951,
"longitude": -77.0364
}
You need to configure conflict resolution to meet the following requirements:
✑ For container1 you must resolve conflicts by using the highest value for policyYear.
✑ For container2 you must resolve conflicts by accepting the distance closest to latitude: 40.730610 and longitude: -73.935242.
✑ Administrative effort must be minimized to implement the solution.
What should you configure for each container? To answer, drag the appropriate configurations to the correct containers. Each configuration may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place: