Confidently Practice Online with Free DP-420 Exam Cram

You are having an index policy as demonstrated in the following diagram:

You are creating an item. When will the index get updated?

You are having an Azure Cosmos DB Core (SQL) API account named account2 that has a container containing 100 GB of data.

In the container, you run the below-given query:

While running the query, you see the below metrics::

Here are some statements regarding the scenario:

Statement 1: The query uses an index.

Statement 2: The query performs a cross-partition query.

Statement 3: Recreating the container with the partition key set to /categoryId will improve the performance of the query.

Which of the above statements are true?

You work in the Intel company that has its clients across 4 different countries, with hundreds of thousands of clients for countries 1 and 2, and a few thousand clients for countries 3 and 4. Requests for every country total approximately 50,000 RU/s every hour of the day. The application team of the company suggests using countryId as the partition key for this container.

 Which of the following statements is true?

There is a database in an Azure Cosmos DB Core (SQL) API account which is backed up every two hours.

You have been asked to implement a solution that will support point-in-time restore. Which of the following thing would you perform first?

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?