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?

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

You need to manage the account by using the Azure Cosmos DB SDK.

What should you do?