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

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.

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 function that uses Azure Cosmos DB Core (SQL) API change feed as a trigger and Azure event hub as the output.

Does this meet the goal?

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 plan to use a multi-region Azure Cosmos DB for NoSQL account to store data for a new application suite. The suite contains the applications shown in the following table.

Each application should use the weakest consistency level possible.

Which consistency level should you configure for each application? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

You have an Azure Cosmos DB container named container! that has a provisioned throughput and two physical partitions. You monitor the following metrics for container1

• Normalized RU consumption

• The percentage of requests that have an HTTP status code of 429

You need to confirm that container1 is configured to maximize resource utilization.

What are the optimal values for each metric? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have a container that stores data about families. The following is a sample document.

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 database named DB1 that hosts a container named Contained. The partition key for Container! is /city.

You are developing a cloud-native app named App1 that will store customer information in DB1. App1 will perform transactional batch operations to update the items in Contained.

You need to configure App1 to meet the following requirements:

• Ensure that batch operations are rolled back if an item ' s ETag value has changed since the value was last read.

• Ensure that all operations in the batch apply to a single partition key value.

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 plan to create an Azure Cosmos DB account that will use the NoSQL API.

You need to create a grouping strategy for items that will be stored in the account. The solution must ensure that write and read operations on the items can be performed within the same transact!

What should you use to group the items?

You maintain a relational database for a book publisher. The database contains the following tables.

The most common query lists the books for a given authorId.

You need to develop a non-relational data model for Azure Cosmos DB Core (SQL) API that will replace the relational database. The solution must minimize latency and read operation costs.

What should you include in the solution?

You have a database in an Azure Cosmos DB for NoSQL account. The database contains a container named container1. The indexing mode container1 is set to none. You configure Azure Cognitive Search to extract data from container1 and make the data searchable. You discover that the Cognitive Search index is missing all the data from the Azure Cosmos DB index. What should you do to resolve the issue?

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 subscription that contains an Azure Cosmos DB for NoSQL database named DB1.

You develop a software as a service (SaaS) app named App1 that uses DB1. App1 will be used by multiple vendors to manage their customers.

You need to create a container in DB1 that will store customer and order details for each vendor. The solution must meet the following requirements:

• Each vendor must have a unique tenant ID.

• The performance of the container must be optimized for reads.

• Customer IDs can be duplicated across the container but must be unique for each vendor.

• The container must be optimized for concurrent queries from multiple customers. Each query will return data for a single vendor.

How should you configure the container?

You have an on-premises computer named Computer1 that runs Windows 11.

On Computer1, you install the Azure Cosmos DB Emulator by using the default settings. You need to connect to the API for NoSQL clients hosted by the emulator. What should you use?

You have a global ecommerce application that stores data in an Azure Cosmos OB for NoSQL account. The account is contoured for multi-region writes.

You need to create a stored procedure for a custom conflict resolution policy for a new container. In the event of a conflict caused by a deletion the deletion must always take priority.

Which parameter should you check m the stored procedure function?

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.

Vou have an Azure subscription. The subscription contains an Azure Cosmos DB for NoSQL account named account1 that hosts a container named Customers. Multi-region writes are allowed.

You execute the following C# code.

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 m an Azure Cosmos DB for NoSQL account.

Data update volumes are unpredictable.

You need to process the change teed of the container by using a web app that has multiple instances. The change feed will be processed by using the change feed processor from the Azure Cosmos DB SDK. The multiple instances must share the workload.

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 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 plan to deploy two Azure Cosmos DB Core (SQL) API accounts that will each contain a single database. The accounts will be configured as shown in the following table.

How should you provision the containers within each account to minimize costs? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have an Azure Cosmos OB 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 are designing an Azure Cosmos DB for NoSQL solution.

You plan to create a new container named Container1 that will store product data for automotive repair pans as shown in the following table.

The data will be stored in Container! as shown in the following table

You need to recommend a data partitioning solution for the database. The solution must spread the workload to minimize I/O contention.

Which column should you recommend for the physical partition key and the logical partition key? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You are developing a web app named App1 that will store customer-generated content in an Azure Cosmos DB for NoSQL database named DB1.

You configure an Azure Al Search indexer to automatically ingest documents from DB1 into an Azure Al Search index.

App1 uses REST APIs to provide advanced search and retrieval capabilities for the documents.

You need to identify which types of queries you can use in Azure Al Search to retrieve text data. The solution must minimize development effort

Which two query types can you use? 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.

You need to create a container in db1 that has the following attributes:

• Name: Contained

• Encryption: Client-side encryption with Always Encrypted

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

You plan to audit changes to the control plane of account1.

You need to ensure that audit events include the details of the security principal that performs each control plane change.

How should you complete the az command? 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 Synapse 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 an Azure Cosmos DB for NoSQL account named account1 that has a single read-write region and one additional read region. Account1 uses the strong default consistency level.

You have an application that uses the eventual consistency level when submitting requests to account1.

How will writes from the application be handled?

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