DP-420 Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB Questions and Answers

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

You need to configure the sink connector for KafkaConnect1 to deliver messages from Topic1 to Container1.

How should you configure the value converter for the sink connector? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

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

You configure account! to send resource logs to Log Analytics.

You need to identify any containers in account1 that were deleted during the past 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 Cosmos DB for NoSQL account that frequently receives the same three queries.

You need to configure indexing to minimize RUs consumed by the queries.

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

NOTE: Each correct selection is worth one point.

You have an Azure subscription.

You need to deploy the following resources to an Azure Cosmos DB for NoSQL account:

• A container

• A user-defined function (UDF)

The solution must minimize the possibility of the deployment failing.

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 operational data in an Azure Cosmos OB for NoSQL database.

Database users report that the performance of the database degrades significantly when a business analytics team runs large Apache Spark-based queries against the database.

You need 10 reduce the impact that running the Spark-based queries has on the database users.

What should you implement?

You have an Azure Cosmos DB for NoSQL account named account1 that supports an application named App1. App1 uses the consistent prefix consistency level.

You configure account1 to use a dedicated gateway and integrated cache.

You need to ensure that App1 can use the integrated cache.

Which two actions should you perform for APP1? Each correct answer presents part of the 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 DB.

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

You have an Azure Cosmos DB for NoSQL database that hosts a container named Container1 For Container1. the DefaultTimeToLive property is -1.

You insert an item into Container1. The property of the inserted item is 10O0. When will the item be deleted automatically?

You plan to create an Azure Cosmos DB Core (SQL) API account that will use customer-managed keys stored in Azure Key Vault.

You need to configure an access policy in Key Vault to allow Azure Cosmos DB access to the keys.

Which three permissions should you enable in the access policy? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

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 have an Azure subscription that contains the resources shown in the following table.

You need to query Container1 from the serverless SQL pool of workspace1.

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 Cosmos DB account named account1.

You have several apps that connect to account1 by using the account ' s secondary key.

You then configure the apps to authenticate by using service principals.

You need to ensure that account1 will only allow apps to connect by using an Azure AD identity.

Which account property should you modify?

You have an Azure Resource Manager (ARM) template that provisions Azure Cosmos DB accounts and databases. The accounts are deployed to a single Azure region. The databases have provisioned throughput configured. The name of the region, the type of database throughput, and the throughput value are defined as template parameters.

You need to modify some of the Azure Cosmos DB accounts and databases based on the following scenarios:

• Scenario 1: Add a read region and increase the database throughput.

• Scenario 2: Change the provisioned database throughput to autoscale.

The solution must minimize administrative effort and the duration of the modifications.

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

NOTE: Each correct selection is worth one point.

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

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

You need to make the contents of container1 available as reference data for an Azure Stream Analytics job.

Solution: You create an Azure Data Factory pipeline that uses Azure Cosmos DB Core (SQL) API as the input and Azure Blob Storage as the output.

Does this meet the goal?

You have a database named db1 in an Azure Cosmos DB for NoSQL

You are designing an application that will use dbl.

In db1, you are creating a new container named coll1 that will store in coll1.

The following is a sample of a document that will be stored in coll1.

The application will have the following characteristics:

• New orders will be created frequently by different customers.

• Customers will often view their past order history.

You need to select the partition key value for coll1 to support the application. The solution must minimize costs.

To what should you set the partition key?

You have the indexing policy shown in the following exhibit.

Use the drop-down menus to select the answer choice that answers each question based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

You have an Azure Cosmos DB for NoSQL database that hosts the containers shown in the following table.

You need to ensure that when a product name changes in the Products container, the product name changes in all orders that have NOT been shipped.

What should you implement?

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 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 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 need to implement a solution to meet the product catalog requirements.

What should you do to implement the conflict resolution policy.

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 select the partition key for con-iot1. The solution must meet the IoT telemetry requirements.

What should you select?

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 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 app named App1 that uses an Azure Cosmos DB for NoSQL database.

App1 uses the spatial columns shown in the following table.

You need to design an indexing strategy for App1.

Which columns can be indexed by using spatial indexes?

You have a container named container! in an Azure Cosmos DB for NoSQL account.

You need to provide a user named User1 with the ability to insert items into container1 by using role-based access The solution must use the principle of least privilege.

Which roles should you assign to User1?

You have three containers in an Azure Cosmos DB Core (SQL) API account as shown in the following table.

You have the following Azure functions:

A function named Fn1 that reads the change feed of cn1

A function named Fn2 that reads the change feed of cn2

A function named Fn3 that reads the change feed of cn3

You perform the following actions:

Delete an item named item1 from cn1.

Update an item named item2 in cn2.

For an item named item3 in cn3, update the item time to live to 3,600 seconds.

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 for NoSQL account. The account hosts a container that has the change feed enabled. You are building an app by using the Azure Cosmos DB SDK. The app will read items from the change feed by using a pull model. You need to ensure that multiple threads can read the change feed in parallel. What should you include?

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

You need to write a SQL query that will return multiple items. The solution must meet the following requirements:

• For each item returned, include the current Coordinated Universal Time (UTC) date and time, formatted as an ISO 8601 string.

• Minimize development effort.

What should you use?

You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. Upserts of items in container1 occur every three seconds.

You have an Azure Functions app named function1 that is supposed to run whenever items are inserted or replaced in container1.

You discover that function1 runs, but not on every upsert.

You need to ensure that function1 processes each upsert within one second of the upsert.

Which property should you change in the Function.json file of function1?

You have an Azure Cosmos DB for NoSQL account1 that is configured for automatic failover. The account1 account has a single read-write region in West US and a and a read region in East US.

You run the following PowerShell command.

What is the effect of running the command?