Question 1

You have a database in an Azure Cosmos DB for NoSQL account that is configured for multi-region writes.

You need to use the Azure Cosmos DB SDK to implement the conflict resolution policy for a container. The

solution must ensure that any conflict sent to the conflict feed.

Solution: You set ConfilictResolutionMode to Custom. You Set ResolutionProcedures to a custom stored

procedure. You configure the custom stored procedure to use the conflictingItems parameter to resolve

conflict.

Does this meet the goal?

Options :

A : Yes

B : No

Answer: A

Question 2

One of your friends needs to troubleshoot the skew storage. Which of the following SQL API Log Analytics tables would you suggest using?

Options :

A : DataPlaneRequests

B : QueryRuntimeStatistics

C : PartitionKeyRUConsumption

D : n

PartitionKeyStatisticsright

E : ControlPlaneRequests

Answer: D

Question 3

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?

Options :

A : This partition key will cause fan out when filtering by countryId

B : This partition key could cause storage hot partitionsright

C : This partition key will prevent throughput hot partitions

D : All the above

Answer: B

Question 4

Azure SQL Database allows configuring MAXDOP for every database and elastic pool. How the query executes also depends a lot on the MAXDOP value. What will happen if the MAXDOP is equal to Zero?

Options :

A : SQL Server database engine won’t execute queries in parallel mode

B : The database engines can use a maximum of 10 parallel threads

C : The database engine can utilize any number of parallel threads with the upper cap constrained by the total number of logical processorsright

D : MAXDOP can’t be 0

Answer: C

Question 5

You have the following query.

SELECT * FROM

WHERE c.sensor = "TEMP1"

AND c.value < 22

AND c.timestamp >= 1619146031231

You need to recommend a composite index strategy that will minimize the request units (RUs) consumed by

the query.

What should you recommend?

Options :

A : a composite index for (sensor ASC, value ASC) and a composite index for (sensor ASC, timestamp ASC)

B : a composite index for (sensor ASC, value ASC, timestamp ASC) and a composite index for (sensor DESC, value DESC, timestamp DESC)

C : a composite index for (value ASC, sensor ASC) and a composite index for (timestamp ASC, sensor ASC)

D : a composite index for (sensor ASC, value ASC, timestamp ASC)

Answer: A

Free DP-420 Mock Exam – Practice Online Confidently

Buying Options: