DP-420 Exam Questions & Answers

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 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 have an Azure Cosmos DB for NoSQL database that hosts a container named Container1 For Container1. the DefaultTimeToLive property is -1.

You insert an item into Container1. The property of the inserted item is 10O0. When will the item be deleted automatically?

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 an Azure Cosmos DB account that hosts a single container named Container1. Container1 contains items that include two properties named Tenantld and Userld. Container1 has logical partitions based on the Tenantld property.

You need to configure subpartitioning for Container1 based on the Userld property. The solution must maximize data availability.

What should you do first?