Free Microsoft DP-420 Exam Questions

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?

You have a container of books with JSON documents that have a string property named title. The JSON documents also have a property named tags which is an array of string values. You need to authorize a SQL query that will create a cross-product of the document titles and tags. Which of the following SQL query would you use?

You have an Azure Cosmos DB database that hosts a container named container1.

You need to ensure that the items stored in container1 will NOT expire unless their TTL value is set explicitly.

What should you do?

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? 

Azure Cosmos DB comes in 2 different capacity modes that are provisioned throughput and serverless.

i). Which of these modes is best suited for Workloads having sustained traffic that require predictable performance?

ii). For which mode, Geo distribution is unavailable?