Question 1

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

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

Options :

A : At a scheduled interval

B : After the item appears in the change feed

C : At the same time as the item creationright

D : The index won’t be updated at all

Answer: C

Question 2

You have a database in an Azure Cosmos DB Core (SQL) API account. The database is backed up every two

hours.

You need to implement a solution that supports point-in-time restore.

What should you do first?

Options :

A : Enable Continuous Backup for the account.

B : Configure the Backup & Restore settings for the account.

C : Create a new account that has a periodic backup policy.

D : Configure the Point In Time Restore settings for the account.

Answer: A

Question 3

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.

Options :

A : Change the connection mode to direct

B : Change the account endpoint to https://account1.sqlx.cosmos.azure.com.

C : Change the consistency level of requests to strong.

D : Change the consistency level of requests to session.

E : Change the account endpoint to https://account1.documents.azure.com

Answer: B,D

Question 4

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?

Options :

A : SELECT VALUE addTax(i.rate) FROM items i

B : SELECT VALUE udf.addTax(i.rate) FROM items iright

C : SELECT VALUE i.rate.addTax() FROM item i

D : SELECT VALUE addTax.rate FROM item i

Answer: B

Question 5

You have an Azure Cosmos DB database.

You plan to create a new container named container1 that will store product data and product category data

and will primarily support read requests.

You need to configure a partition key for container1. The solution must meet the following requirements:

Minimize the size of the partition.

Minimize maintenance effort.

Which two characteristics should you prioritize? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Options :

A : unique

B : high cardinality

C :

low cardinality

D : static

Answer: B,D