What is this exam about?

Azure Cosmos DB application design and implementation.

You have an Azure Cosmos DB Core (SQL) API account that uses a custom conflict resolution policy. The account has a registered merge procedure that throws a runtime exception. The runtime exception prevents conflicts from being resolved. You need to use an Azure function to resolve the conflicts. What should you use?

Correct Answer: a function that pulls items from the conflicts feed and is triggered by a timer trigger

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?

Correct Answer: Add a custom indexing policy to the con-product container.

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?

Correct Answer: Gateway mode (using HTTPS)

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?

Correct Answer: Modify the connection policy of App1.

The following is a sample of a document in orders. The orders container uses customerId as the partition key. You need to provide a report of the total items ordered per month by item type. The solution must meet the following requirements: ✑ Ensure that the report can run as quickly as possible. ✑ Minimize the consumption of request units (RUs). What should you do?

Correct Answer: Configure the report to query a new aggregate container. Populate the aggregates by using the change feed.

You have an Azure Cosmos DB Core (SQL) API account that has multiple write regions. You need to receive an alert when requests that target the database exceed the available request units per second (RU/s). Which Azure Monitor signal should you use?

Correct Answer: Provisioned Throughput

You need to implement a solution for the planned changes and meet the product catalog requirements. What should you do to implement the conflict resolution policy?

Correct Answer: Create a new container and migrate the product catalog data to the new container

The settings for a container in an Azure Cosmos DB Core (SQL) API account are configured as shown in the following exhibit. Which statement describes the configuration of the container?

Correct Answer: Items stored in the collection will expire only if the item has a time to live value.

You have the following query. You need to recommend a composite index strategy that will minimize the request units (RUs) consumed by the query. What should you recommend?

Correct Answer: a composite index for (sensor ASC, value ASC) and a composite index for (sensor ASC, timestamp ASC)

You need to create a database in an Azure Cosmos DB Core (SQL) API account. The database will contain three containers named coll1, coll2, and coll3. The coll1 container will have unpredictable read and write volumes. The coll2 and coll3 containers will have predictable read and write volumes. The expected maximum throughput for coll1 and coll2 is 50,000 request units per second (RU/s) each. How should you provision the collection while minimizing costs?

Correct Answer: Create a provisioned throughput account. Set the throughput for coll1 to Autoscale. Set the throughput for coll2 and coll3 to Manual.

You have an Azure Cosmos DB Core (SQL) API account named account1 that is configured for automatic failover. The account1 account has a single read-write region in West US and a read region in East US. You run the following PowerShell command. Update-AzCosmosDBAccountFailoverPriority -ResourceGroupName `rg1` -Name `account1` -FailoverPolicy @(`East US`, `West US`) What is the effect of running the command?

Correct Answer: The account will be unavailable to writes during the change

You have a database in an Azure Cosmos DB Core (SQL API) account. The database contains a container named container1. The indexing mode of 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?

Correct Answer: Change the indexing mode of container1 to consistent

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?

Correct Answer: Create a new synthetic key that contains deviceId and a random number.

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?

Correct Answer: Create a container for Author and a container for Book. In each Author document, embed bookId for each book by the author. In each Book document embed authorId of each author.

You have a container named container1 in an Azure Cosmos DB Core (SQL) API account named account1 that is set to the session default consistency level. The average size of an item in contained is 20 KB. 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?

Correct Answer: In account1, provision a dedicated gateway and integrated cache

You have an Azure Cosmos DB Core (SQL) API account. You run the following query against a container in the account. What is the output of the query?

Correct Answer: [{"A": false, "B": true, "C": false}]

You have an Azure Cosmos DB Core (SQL) API account. The change feed is enabled on a container named invoice. You create an Azure function that has a trigger on the change feed. What is received by the Azure function?

Correct Answer: all the properties of the updated items

You have an application that queries an Azure Cosmos DB Core (SQL) API account. You discover that the following two queries run frequently. You need to minimize the request units (RUs) consumed by reads and writes. What should you create?

Correct Answer: a composite index for (name ASC, timestamp ASC) and a composite index for (name DESC, timestamp DESC)

You need to implement a trigger in Azure Cosmos DB Core (SQL) API that will run before an item is inserted into a container. Which two actions should you perform to ensure that the trigger runs? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Correct Answer: Register the trigger as a pre-trigger.

You have an Azure Cosmos DB Core (SQL) API 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?

Correct Answer: Writes will use the strong consistency level.

You are implementing an Azure Data Factory data flow that will use an Azure Cosmos DB (SQL API) sink to write a dataset. The data flow will use 2,000 Apache Spark partitions. You need to ensure that the ingestion from each Spark partition is balanced to optimize throughput. Which sink setting should you configure?

Correct Answer: Write throughput budget

You have a database named db1 in an Azure Cosmos DB Core (SQL) API account named account1. You need to write JSON data to db1 by using Azure Stream Analytics. The solution must minimize costs. Which should you do before you can use db1 as an output of Stream Analytics?

Correct Answer: In db1, create containers that have a custom indexing policy and analytical store disabled

You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. You need to provide a user named User1 with the ability to insert items into container1 by using role-based access control (RBAC). The solution must use the principle of least privilege. Which roles should you assign to User1?

Correct Answer: Cosmos DB Built-in Data Contributor only

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 transaction. What should you use to group the items?

Correct Answer: logical partitions

You have a database named db1 in an Azure Cosmos DB Core (SQL) API account. You have a third-party application that is exposed through a REST API. You need to migrate data from the application to a container in db1 on a weekly basis. What should you use?

Correct Answer: Azure Data Factory

You have a database in an Azure Cosmos DB Core (SQL) API account. The database is backed up every two hours. You need to implement a solution that supports point-in-time restore. What should you do first?

Correct Answer: Enable Continuous Backup for the account.

You have an Azure Cosmos DB database named database1 that contains a container named container1. The container1 container stores product data and has the following indexing policy. Which path will be indexed?

Correct Answer: /product/category

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?

Correct Answer: weaker consistency for read operations

You develop an application that uses Azure Cosmos DB Core (SQL) API. You create an Azure pipeline to build and deploy the application. You need to change the pipeline to run integration tests that you wrote for the application. The solution must execute entirely in the pipeline. What should you add to the pipeline?

Correct Answer: a secret variable that has a connection string to an Azure Cosmos DB database

You have a database in an Azure Cosmos DB Core (SQL) API account. You need to create an Azure function that will access the database to retrieve records based on a variable named accountnumber. The solution must protect against SQL injection attacks. How should you define the command statement in the function?

Correct Answer: cmd = "SELECT * FROM Persons p WHERE p.accountnumber = @accountnumber"

You plan to implement an Azure Cosmos DB container that will store telemetry data from 1,000 IoT devices. The data will be updated once every minute. An app will read the data once daily and generate aggregated reports that summarize the state of each device. You need to configure a partition key for the container. The solution must meet the following requirements: • Minimize the possibility of reaching the partition limits. • Spread read and write operations evenly across the partitions. • Minimize how long it takes to locate a specific set of telemetry values. To what should you set the partition key?

Correct Answer: the device ID and date

Welcome to awslagi.com – Sharing AWS, Google Cloud, Microsoft Azure IT Exams. It's free for all!

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

Design and implement cloud-native applications using Azure Cosmos DB.

4.8★★★★★(177 ratings)

17,679 studentsIntermediate

Learn to build applications around Azure Cosmos DB for globally distributed, scalable data solutions. The exam focuses on data modeling, querying, partitioning, and performance in cloud-native architectures. This certification is useful for developers working with modern distributed applications. It helps you design data layers that support responsiveness, scale, and multi-region growth.

What you'll learn

Model data for Cosmos DB- Query distributed data- Optimize partitioning- Improve performance- Build cloud-native apps

DP-420

Lectures1

Quizzes0

Duration30 week

Students17,679

$20.00

📢 Unlock Full Access to Success!

"The content displayed here is a promotional preview and contains only 50% of the actual exam database. To access the complete set of updated questions, please upgrade to the Full Version."

👉 Click the button and follow the instructions to secure your full access immediately!