You have a container in an Azure Cosmos DB Core (SQL) API account.
You need to use the Azure Cosmos DB SDK to replace a document by using optimistic concurrency.
What should you include in the code? 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 select the partition key for con-iot1. The solution must meet the IoT telemetry requirements.
What should you select?
You need to implement a solution to meet the product catalog requirements.
What should you do to implement the conflict resolution policy.
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 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 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?
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?
You have a database in an Azure Cosmos DB Core (SQL) API account.
You plan to create a container that will store employee data for 5,000 small businesses. Each business will have up to 25 employees. Each employee item will have an emailAddress value.
You need to ensure that the emailAddress value for each employee within the same company is unique.
To what should you set the partition key and the unique key? 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 an Azure Cosmos DB for NoSQL account. The account hosts a container named Container1 that stores customer data. Each customer data item includes the customer ' s name and zero or more related business categories in an array.
You need identify customers that have one of their business categories set to " retail " . The solution must return the customerName and businessCategories fields.
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 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?
You have an application named App1 that reads the data in an Azure Cosmos DB Core (SQL) API account. App1 runs the same read queries every minute. The default consistency level for the account is set to eventual.
You discover that every query consumes request units (RUs) instead of using the cache.
You verify the IntegratedCacheiteItemHitRate metric and the IntegratedCacheQueryHitRate metric. Both metrics have values of 0.
You verify that the dedicated gateway cluster is provisioned and used in the connection string.
You need to ensure that App1 uses the Azure Cosmos DB integrated cache.
What should you configure?
You provision Azure resources by using the following Azure Resource Manager (ARM) template.

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 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?
You have an Azure Cosmos DB for NoSQL 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?
You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named accounts In account1, you create a container that has the following configurations:
• Partition key: CompanylD
• Composite unique key: UserName and EmailAddress
To the container, you plan to add the data items shown in the following table.

How many conflicts will occur?
You have an Azure subscription that contains the resources shown in the following table.

You need to store the account key of account1 in KV1. What should you use?
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 a database in an Azure Cosmos DB for NoSQL account that is configured for multi-region writes.
You need to use the Azure Cosmos DB SDK to implement the conflict resolution policy for a container. The solution must ensure that any conflict sent to the conflict feed.
Solution: You set ConfilictResolutionMode to Custom and you use the default settings for the policy.
Does this meet the goal?
You have an Azure Cosmos DB for NoSQL account.
You need to perform detailed troubleshooting to view the deobfuscated query of all requests. What should you enable in the Azure portal?
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 account. The account contains a database named DB1 and an Azure Key Vault named KV1.
You need to create a container named Container1 in DB1. The solution must ensure that the properties of the items in Container1 are encrypted by using Always Encrypted.
Which four 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 need to configure an Apache Kafka instance to ingest data from an Azure Cosmos DB Core (SQL) API account. The data from a container named telemetry must be added to a Kafka topic named iot. The solution must store the data in a compact binary format.
Which three configuration items should you include in the solution? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You have an Azure Cosmos DB for NoSQL account named account1.
You have an app named App1 that connects to account1 and uses strong consistency for all requests.
You implement the Azure Cosmos DB integrated cache for account1.
You need to ensure that App1 uses the integrated cache.
What should you do?
You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named accounts In account1, you plan to create a container that will store the data items shown in the following table.

Each customer item will have customer sales by month values embedded.
The most executed query will return data for a matrix that aggregates the monthly sales ot each business category. The matrix will use customer business categories as columns and months as rows.
You need to configure the partition key for the container. The solution must minimize the request units (RUs) required to run th e query.
Which property should you use for the partition key?
You have an Azure Cosmos DB for NoSQL account that hosts a container named Customers. You need to add customers to Customers by using the Azure Cosmos DB Spark Connector. How should you complete the code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

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.

You have an Azure Cosmos DB container named container1.
You need to insert an item into contained. The solution must ensure that the item is deleted automatically after two hours.
How should you complete the item definition? 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 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?
You have a container in an Azure Cosmos DB for NoSQL account.
You need to create an alert based on a custom Log Analytics query.
Which signal type should you use?
You have an Azure Cosmos DB for NoSQL account that contains a database named DB1. Users run the following query against DB1.

You add an index to the recordset.
You need to change the ORDER by syntax of the query to optimize the use of the index. The solution must NOT change the result set.
Which syntax should you use?
Which syntax should you use?
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 an Azure Cosmos DB for NoSQL 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?
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 are developing an application that will connect to an Azure Cosmos DB for NoSQL account. The account has a single readme region and one agonal read region. The regions are configured for automatic failover.
The account has the following connect strings. (Line numbers are included for reference only.)

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 that contains a container named container1.
You plan to use container1 as a key-value store that will perform point reads on the item ID and partition key.
You need to define an indexing policy for container! The solution must meet the following requirements:
• Provide the ability to set DefauitTimeToLive for container1.
• Minimize implementation time.
• Minimize costs.
How should you complete the JSON definition of the indexing policy? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Microsoft Certified: Azure Cosmos DB Developer Specialty | DP-420 Exam Topics | DP-420 Questions answers | DP-420 Test Prep | Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB Exam Questions PDF | DP-420 Online Exam | DP-420 Practice Test | DP-420 PDF | DP-420 Test Questions | DP-420 Study Material | DP-420 Exam Preparation | DP-420 Valid Dumps | DP-420 Real Questions | Microsoft Certified: Azure Cosmos DB Developer Specialty DP-420 Exam Questions