Free Preparation Discussions
MENU
Microsoft DP-420 Exam Questions
Free Microsoft DP-420 Exam Actual Questions
Note: Premium Questions for DP-420 were last updated On May. 10, 2026 (see below)
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 Core (SQL) API account.
You need to make the contents of container1 available as reference data for an Azure Stream Analytics job.
Solution: You create an Azure Synapse pipeline that uses Azure Cosmos DB Core (SQL) API as the input and Azure Blob Storage as the output.
Does this meet the goal?
Instead create an Azure function that uses Azure Cosmos DB Core (SQL) API change feed as a trigger and Azure event hub as the output.
The Azure Cosmos DB change feed is a mechanism to get a continuous and incremental feed of records from an Azure Cosmos container as those records are being created or modified. Change feed support works by listening to container for any changes. It then outputs the sorted list of documents that were changed in the order in which they were modified.
The following diagram represents the data flow and components involved in the solution:
You have an Azure Cosmos DB for NoSQL database named db1 that writes to multiple Azure regions. You need to test the performance of db1 in the secondary region. Which command should you run first?
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 assign to User1?
Cosmos DB Operator: Can provision Azure Cosmos accounts, databases, and containers. Cannot access any data or use Data Explorer.
Incorrect Answers:
B: DocumentDB Account Contributor can manage Azure Cosmos DB accounts. Azure Cosmos DB is formerly known as DocumentDB.
C: DocumentDB Account Contributor: Can manage Azure Cosmos DB accounts.
You need to configure an Apache Kafka instance to ingest data from an Azure Cosmos DB Core (SQL) API 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.
C: Avro is binary format, while JSON is text.
F: Kafka Connect for Azure Cosmos DB is a connector to read from and write data to Azure Cosmos DB. The Azure Cosmos DB sink connector allows you to export data from Apache Kafka topics to an Azure Cosmos DB database. The connector polls data from Kafka to write to containers in the database based on the topics subscription.
D: Create the Azure Cosmos DB sink connector in Kafka Connect. The following JSON body defines config for the sink connector.
Extract:
'connector.class': 'com.azure.cosmos.kafka.connect.sink.CosmosDBSinkConnector',
'key.converter': 'org.apache.kafka.connect.json.AvroConverter'
'connect.cosmos.containers.topicmap': 'hotels#kafka'
Incorrect Answers:
B: JSON is plain text.
Note, full example:
{
'name': 'cosmosdb-sink-connector',
'config': {
'connector.class': 'com.azure.cosmos.kafka.connect.sink.CosmosDBSinkConnector',
'tasks.max': '1',
'topics': [
'hotels'
],
'value.converter': 'org.apache.kafka.connect.json.AvroConverter',
'value.converter.schemas.enable': 'false',
'key.converter': 'org.apache.kafka.connect.json.AvroConverter',
'key.converter.schemas.enable': 'false',
'connect.cosmos.connection.endpoint': 'https://<cosmosinstance-name>.documents.azure.com:443/',
'connect.cosmos.master.key': '<cosmosdbprimarykey>',
'connect.cosmos.databasename': 'kafkaconnect',
'connect.cosmos.containers.topicmap': 'hotels#kafka'
}
}
https://docs.microsoft.com/en-us/azure/cosmos-db/sql/kafka-connector-sink
https://www.confluent.io/blog/kafka-connect-deep-dive-converters-serialization-explained/
You have an Azure Cosmos DB database named databaset contains a container named container1. The container1 container store product data and has the following indexing policy.
Which path will be indexed?
The indexing policy has an includedPaths array that contains only one path: /product/brand/? . This means that only the properties under /product/brand will be indexed. The ?symbol indicates that only scalar values will be indexed, not arrays or objects1.
The excludedPaths array contains a single path: /* . This means that all other properties will be excluded from indexing.The * symbol indicates a wildcard that matches any property name1.
Therefore, the paths /product/category , /product/[ ]/category , and /product/brand/tailspin will not be indexed.
- Select Question Types you want
- Set your Desired Pass Percentage
- Allocate Time (Hours : Minutes)
- Create Multiple Practice tests with Limited Questions
- Customer Support
Sarah Evans
7 days agoGeorge Jackson
18 days agoLisa Nelson
9 days agoEmily Evans
14 days agoRobert Rivera
4 days agoSarah Johnson
14 days agoEdward Murphy
15 days agoChi
1 month agoEarleen
1 month agoIluminada
2 months agoLeanna
2 months agoPamella
2 months agoDenny
2 months agoJame
3 months agoMajor
3 months agoTimmy
3 months agoJohnathon
3 months agoQuentin
4 months agoMaryann
4 months agoTina
4 months agoPage
4 months agoBea
5 months agoTeri
5 months agoCoral
5 months agoJohna
5 months agoRaymon
6 months agoDominic
6 months agoMauricio
6 months agoEsteban
6 months agoMartina
7 months agoMagnolia
7 months agoHui
7 months agoBrandon
7 months agoKaitlyn
8 months agoMari
8 months agoAdelaide
8 months agoGerman
8 months agoWilburn
10 months agoLili
11 months agoAlecia
1 year agoTiffiny
1 year agoRessie
1 year agoIvory
1 year agoErick
1 year agoRosalind
1 year agoShawnta
1 year agoCheryl
1 year agoLaticia
1 year agoWendell
2 years agoNoemi
2 years agoCatarina
2 years agoMari
2 years agoGregg
2 years agoSage
2 years agoGlen
2 years agoAlysa
2 years agoSanjuana
2 years agoGilma
2 years agoMatilda
2 years agoPrecious
2 years agoYoulanda
2 years agoZachary
2 years agoLeota
2 years agoMaurine
2 years agoAracelis
2 years agoKattie
2 years agoTeddy
2 years ago