Microsoft DP-420 Actual Free Exam Questions & Community Discussion

You need to configure an Apache Kafka instance to ingest data from an Azure Cosmos DB for NoSQL account. The data from a container named telemetry must be added to a Kafka topic named iot.
The solution must store the data in a compact binary format.
Which three configuration items should you include in the solution? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

Hotspot Question
You have an Azure subscription that contains the resources shown in the following table.

You need to query Container1 from the serverless SQL pool of workspace1.
How should you complete the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Hotspot Question
You plan to deploy multi-master support for an Azure Cosmos DB for NoSQL account by using an Azure Resource Manager (ARM) template. The deployment will perform the following actions:
- Create a database in the account.
- Create a container in the database.
- Configure Azure Synapse Link support the account.
You need to configure the conflictResolutionPolicy property and the analyticalStorageTtl property in the template.
Which namespace should you use for each property? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Drag and Drop Question
You have an Azure subscription that contains the resources shown in the following table.

In CosmosDB1, you plan to create a container named Container1 that will store sensitive data.
You need to ensure that Container1 uses Always Encrypted for Azure Cosmos DB.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

You plan to implement an Azure Cosmos DB container that will store telemetry data from 1,000 IoT devices. The data will be updated once every minute. An app will read the data once daily and generate aggregated reports that summarize the state of each device.
You need to configure a partition key for the container. The solution must meet the following requirements:
- Minimize the possibility of reaching the partition limits.
- Spread read and write operations evenly across the partitions.
- Minimize how long it takes to locate a specific set of telemetry
values.
To what should you set the partition key?

The following is a sample of a document in orders.

The orders container uses customerId as the partition key.
You need to provide a report of the total items ordered per month by item type. The solution must meet the following requirements:
- Ensure that the report can run as quickly as possible.
- Minimize the consumption of request units (RUs).
What should you do?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a container named container1 in an Azure Cosmos DB for NoSQL account.
You need to make the contents of container1 available as reference data for an Azure Stream Analytics job.
Solution: You create an Azure function to copy data to another Azure Cosmos DB for NoSQL container.
Does this meet the goal?

Which of the following is the most optimal method of managing referential integrity between different containers in Azure Cosmos DB?

You are implementing an Azure Data Factory data flow that will use an Azure Cosmos DB for NoSQL sink to write a dataset. The data flow will use 2,000 Apache Spark partitions.
You need to ensure that the ingestion from each Spark partition is balanced to optimize throughput.
Which sink setting should you configure?

You have a container in an Azure Cosmos DB for NoSQL account.
Data update volumes are unpredictable.
You need to process the change feed of the container by using a web app that has multiple instances. The change feed will be processed by using the change feed processor from the Azure Cosmos DB SDK. The multiple instances must share the workload.
Which three actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

You plan to deploy an Azure Cosmos DB for NoSQL account that will contain orders and the order lines of each order.
You need to recommend an account design that will maximize performance and minimize the cost of reading a single order and its order lines.
What should you recommend?

You have an Azure Cosmos DB for NoSQL account named account1.
You plan to implement shared database containers in account1.
Upon which two properties is the throughput of a specific container dependent? Each correct answer presents part of the solution.
NOTE: Each correct answer is worth one point.