Free Microsoft DP-420 Exam Questions

You have a container of books with JSON documents that have a string property named title. The JSON documents also have a property named tags which is an array of string values. You need to authorize a SQL query that will create a cross-product of the document titles and tags. Which of the following SQL query would you use?

An Azure Cosmos DB Core (SQL) API account has a container that stores telemetry data from IoT devices. The container utilizes telemetryId as the partition key and has a throughput of 1000 RU/s (request units per second). Data is submitted by approx 5000 IoT devices by using the same telemetryId value every 5 minutes.

You have an app that does analytics on the data and reads telemetry data frequently for a single IoT device to have the trend analysis.

The below figure demonstrates the sample of a document in the container:

What would you do for reducing the number of RUs consumed by the analytics app?

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

Each transaction in a Cosmos Database provides ACID property guarantees. Which of these ACID properties ensures that the data is always in a valid state across transactions?