DP-420 exam

HOTSPOT You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. The following is a sample of a document in container1. { "studentId": "631282", "firstName": "James", "lastName": "Smith", "enrollmentYear": 1990, "isActivelyEnrolled": true, "address": { "street": "", "city": "", "stateProvince": "", "postal": "", } } The...

HOTSPOT You have an Azure Cosmos DB Core (SQL) API account named account1 that has the disableKeyBasedMetadataWriteAccess property enabled. You are developing an app named App1 that will be used by a user named DevUser1 to create containers in account1. DevUser1 has a non-privileged user account in the Azure Active...

You need to select the partition key for con-iot1. The solution must meet the IoT telemetry requirements. What should you select?A . the timestampB . the humidityC . the temperatureD . the device IDView AnswerAnswer: D Explanation: The partition key is what will determine how data is routed in the...

You have a container in an Azure Cosmos DB Core (SQL) API account. The container stores telemetry data from IoT devices. The container uses telemetryId as the partition key and has a throughput of 1,000 request units per second (RU/s). Approximately 5,000 IoT devices submit data every five minutes by...

You are designing an Azure Cosmos DB Core (SQL) API solution to store data from IoT devices. Writes from the devices will be occur every second. The following is a sample of the data. You need to select a partition key that meets the following requirements for writes: - Minimizes...

You are developing an application that will use an Azure Cosmos DB Core (SQL) API account as a data source. You need to create a report that displays the top five most ordered fruits as shown in the following table. A collection that contains aggregated data already exists. The following...

Topic 2, Misc. Questions You have an application named App1 that reads the data in an Azure Cosmos DB Core (SQL) API account. App1 runs the same read queries every minute. The default consistency level for the account is set to eventual. You discover that every query consumes request units...

HOTSPOT You have the indexing policy shown in the following exhibit. Use the drop-down menus to select the answer choice that answers each question based on the information presented in the graphic. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: ORDER BY c.name DESC, c.age...

HOTSPOT You have an Azure Cosmos DB Core (SQL) account that has a single write region in West Europe. You run the following Azure CLI script. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point....

You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. You need to provide a user named User1 with the ability to insert items into container1 by using role-based access control (RBAC). The solution must use the principle of least privilege. Which roles should you...