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

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

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 for NoSQL account named account1 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?

One of your friends has written a user-defined function named ’addTax’. He needs to write a SQL query to return a flat array of scalar Rate values with the calculated tax value. Which of the following is the valid SQL query to use for this purpose?

You plan to create an Azure Cosmos DB for NoSQL database named db1 that will contain two containers. One of the containers will contain blog posts, and the other will contain users. Each item in the blog post container will include:

• A single blog post

• The top 10 comments associated to the blog post

• The names of the users who created the blog post and the associated comments

You need to automatically update the usernames in the blog post container whenever a username in the user container changes.

What should you implement for the user container?

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?