Free Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB Exam DP-420 Exam Practice Test

You have an Azure Cosmos DB for NoSQL account.You need to create an Azure Monitor query that lists recent modifications to the regional failover policy.Which Azure Monitor table should you query?

• CDBPartitionKeyStatistics
• CDBQueryRunTimeStatistics
• CDBDataPlaneRequests
• CDBControlPlaneRequests

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?

• conf1ictingItems
• is Tombstone
• existingitem
• incoming1tem

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 an Azure Cosmos DB Core (SQL) API account named account 1 that uses autoscale throughput.You need to run an Azure function when the normalized request units per second for a container in account1 exceeds a specific value.Solution: You configure an Azure Monitor alert to trigger the function.Does this meet the goal?

• Yes
• No

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.

• Change the connection mode to direct
• Change the account endpoint to https://account1.sqlx.cosmos.azure.com.
• Change the consistency level of requests to strong.
• Change the consistency level of requests to session.
• Change the account endpoint to https://account1.documents.azure.com

You need to select the partition key for con-iot1. The solution must meet the IoT telemetry requirements.What should you select?

• the timestamp
• the humidity
• the temperature
• the device ID

You have an Azure Cosmos DB Core (SQL) API account.You run the following query against a container in the account.SELECTIS_NUMBER('1234') AS A,IS_NUMBER(1234) AS B,IS_NUMBER({prop: 1234}) AS CWhat is the output of the query?

• [{'A': false, 'B': true, 'C': false}]
• [{'A': true, 'B': false, 'C': true}]
• [{'A': true, 'B': true, 'C': false}]
• [{'A': true, 'B': true, 'C': true}]

You have an Azure Cosmos DB Core (SQL) API account that is used by 10 web apps.You need to analyze the data stored in the account by using Apache Spark to create machine learning models. The solution must NOT affect the performance of the web apps.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

• In an Apache Spark pool in Azure Synapse, create a table that uses cosmos.olap as the data source.
• Create a private endpoint connection to the account.
• In an Azure Synapse Analytics serverless SQL pool, create a view that uses OPENROWSET and the CosmosDB provider.
• Enable Azure Synapse Link for the account and Analytical store on the container.
• In an Apache Spark pool in Azure Synapse, create a table that uses cosmos.oltp as the data source.

You are building an application that will store data in an Azure Cosmos DB for NoSQL account. The account uses the session default consistency level. The account is used by five other applications. The account has a single read-write region and 10 additional read regions.Approximately 20 percent of the items stored in the account are updated hourly.Several users will access the new application from multiple devices.You need to ensure that the users see the same item values consistently when they browse from the different devices. The solution must not affect the other applications.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

• Use implicit session management when performing read requests.
• Provide a stored session token when performing read requests.
• Associate a session token to the user account.
• Set the default consistency level to eventual.
• Associate a session token to the device.

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?

• Azure Synapse Link
• a default consistency level of Consistent Prefix
• a default consistency level of Strong
• the Spark connector

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?

• logical partitions
• physical partitions
• databases
• containers