Question 1

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

Question 2

Container2 is a container in an Azure Cosmos DB Core (SQL) API account where Upserts of items happen every three seconds.

You are having an Azure Functions application named function2 that is expected to run whenever the items are replaced or inserted in container2.

You notice that function2 runs, but not on each upsert.

You need to make sure that each upsert is processed by function2 within 1 second of the upsert. Which of the following property should you modify in the Function.json file of function2?

Options :

A : MaxItemsPerInvocation

B : FeedPollDelayright

C : CheckpointInterval

D : leaseCollectionsThroughput

Answer: B

Question 3

You have recently joined a new company as an App developer. Which of the following metrics would you check to know if your application uses the dedicated gateway or not?

Options :

A : IntegratedCacheItemHitRate

B : DedicatedGatewayRequestsright

C : IntegratedCacheQueryHitRate

D : DedicatedGatewayApps

Answer: B

Question 4

You are working on an app that will save the device metrics produced every minute by various IoT devices. You decide to collect the data for two entities; the devices and the device metrics produced by each device. You were about to create two containers for these identified entities but suddenly your data engineer suggests you place both entities in a single container, not two different containers. You would like to be able to track the general data of the device and the number of metrics collections per device. How could we keep track of these entities inside the container?

Options :

A : Add a new property to your device documents called metricscollectioncount and update it with the current number of metrics collection documents. Subtract 1 from the metricscollectioncount property when your app or Azure function adds a new metrics collection

B : Add a new property to your device documents called metricscollectioncount and update it with the current number of metrics collection documents. Add 1 to the metricscollectioncount property inside a transactional batch when your app or Azure function adds a new metrics collectionright

C : Use a GROUP BY parameter in your query and use the aggregate count to return the number of device metrics collections per device

D : Use a GROUP BY parameter in your query and use the aggregate sum to return the number of device metrics collections per device

Answer: B

Question 5

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

Higher Test Marks with Free Online DP-420 Exam Practice

Buying Options: