Question 1

Azure Cosmos DB comes in 2 different capacity modes that are provisioned throughput and serverless.

i). Which of these modes is best suited for Workloads having sustained traffic that require predictable performance?

ii). For which mode, Geo distribution is unavailable?

Options :

A : i) provisioned throughput and ii) Serverlessright

B : i) Serverless and ii) Provisioned throughput

C : i) Provisioned throughput and ii) Provisioned throughput

D : i) Serverless and ii) Serverless

Answer: A

Question 2

You want to disable all indexing for a container in Azure Cosmos Database. Which of the following property of the indexing policy would help you in meeting the goal?

Options :

A : excludedPaths

B : includedPath

C : automatic

D : indexingModeright

Answer: D

Question 3

You have a database in an Azure Cosmos DB Core (SQL) API account. You need to create an Azure function that will access the database to retrieve records based on a variable named accountnumber. The solution must protect against SQL injection attacks. How should you define the command statement in the function?

Options :

A : cmd = "SELECT * FROM Persons p WHERE p.accountnumber = 'accountnumber'"

B : cmd = "SELECT * FROM Persons p WHERE p.accountnumber = LIKE @accountnumber"

C : cmd = "SELECT * FROM Persons p WHERE p.accountnumber = @accountnumber"

D : cmd = "SELECT * FROM Persons p WHERE p.accountnumber = '" + accountnumber + "'"

Answer: C

Question 4

You need to implement a solution to meet the product catalog requirements. What should you do to implement the conflict resolution policy.

Options :

A : Remove frequently changed field from the index policy of the con-product container.

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

C : Set the default consistency level for account1 to eventual.

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

Answer: D

Question 5

While working in .NET SDK v3, you need to enable multi-region writes in your app that uses Azure Cosmos DB. WestUS2 is the region where your application would be deployed and Cosmos DB is replicated.

Which of the following attributes would you set to WestUS2 to achieve the goal?

Options :

A : ApplicationRegionright

B : SetCurrentLocation

C : setPreferredLocations

D : connection_policy.PreferredLocations

Answer: A

Free DP-420 Mock Exam – Practice Online Confidently

Buying Options: