Question 1

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 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 have an Azure Cosmos DB for NoSQL account that has multiple write regions. You need to receive an alert when requests that target the database exceed the available request units per second (RU/s). Which Azure Monitor signal should you use?

Options :

A : Region Removed

B : Document Quota

C : Metadata Requests

D : Data Usage

Answer: B

Question 4

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 5

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

Free DP-420 Mock Exam – Practice Online Confidently

Buying Options: