Question 1

You have operational data in an Azure Cosmos OB for NoSQL database. Database users report that the performance of the database degrades significantly when a business analytics team runs large Apache Spark-based queries against the database. You need 10 reduce the impact that running the Spark-based queries has on the database users. What should you implement?

Options :

A : Azure Synapse Link

B : a default consistency level of Consistent Prefix

C : a default consistency level of Strong

D : the Spark connector

Answer: A

Question 2

You need to implement a solution for the planned changes and meet the product catalog requirements.

What should you do to implement the conflict resolution policy?

Options :

A : Set the default consistency level for account1 to eventual

B : Remove frequently changed fields from the index policy of the con-product container

C : Create a new container and migrate the product catalog data to the new container

D : Disable indexing on all fields in the index policy of the con-product container

Answer: A

Question 3

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 4

One of the team members has recently joined the team and wants to manually adjust the time for which the items will remain in the cache. He asks you for help about which property from the ItemRequestOptions class should he configure. What would you suggest?

Options :

A : ConsistencyLevel

B : SessionToken

C : MaxIntegratedCacheStalenessright

D : None of these

Answer: C

Question 5

You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. You need to provide a user named User1 with the ability to insert items into container1 by using role-based access control (RBAC). The solution must use the principle of least privilege. Which roles should you assign to User1?

Options :

A : CosmosDB Operator only

B : DocumentDB Account Contributor and Cosmos DB Built-in Data Contributor

C : DocumentDB Account Contributor only

D : Cosmos DB Built-in Data Contributor only

Answer: D