Microsoft DP-420 Free Sample Exam Questions 2026

Here you can get the actual Microsoft DP-420 exam questions and answers in PDF for free and for all questions premium file. These best Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB Exam DP-420 PDF questions are for every Microsoft users. Real DP-420 exam dumps that will assist you to crack the %certification% certification exam in the PDF format. For Advance preparation premium PDF files available for perfect exam preparation on reilable price option.

UNLOCK FULL
DP-420 Exam Features

In Just $59 You can Access

• All Official Question Types
• Interactive Web-Based Practice Test Software
• No Installation or 3rd Party Software Required
• Customize your practice sessions (Free Demo)
• 24/7 Customer Support

Get Full Access

Page: 1 / 21
Total Questions: 102

Questions & Answers PDF

• Question 1

  

  You have a database in an Azure Cosmos DB Core (SQL) API account.You need to create an Azure function that will access the database to retrieve records based on a variable named accountnumber. The solution must protect against SQL injection attacks.How should you define the command statement in the function?

  • cmd = 'SELECT * FROM Persons p WHERE p.accountnumber = 'accountnumber''
  • cmd = 'SELECT * FROM Persons p WHERE p.accountnumber = LIKE @accountnumber'
  • cmd = 'SELECT * FROM Persons p WHERE p.accountnumber = @accountnumber'
  • cmd = 'SELECT * FROM Persons p WHERE p.accountnumber = '' + accountnumber + '''

  Reveal Answer Answer: C Next Question

• Question 2

  

  You have an Azure Cosmos DB Core (SQL) API account that uses a custom conflict resolution policy. The account has a registered merge procedure that throws a runtime exception.The runtime exception prevents conflicts from being resolved.You need to use an Azure function to resolve the conflicts.What should you use?

  • a function that pulls items from the conflicts feed and is triggered by a timer trigger
  • a function that receives items pushed from the change feed and is triggered by an Azure Cosmos DB trigger
  • a function that pulls items from the change feed and is triggered by a timer trigger
  • a function that receives items pushed from the conflicts feed and is triggered by an Azure Cosmos DB trigger

  Reveal Answer Answer: D Next Question

• Question 3

  

  You plan to store order data in Azure Cosmos DB for NoSQL account. The data contains information about orders and their associated items.You need to develop a model that supports order read operations. The solution must minimize the number or requests.

  • Create a single database that contains one container. Store orders and order items in separate documents in the container.
  • Create a single database that contains one container. Create a separate document for each order and embed the order items into the order documents.
  • Create a database for orders and a database for order items.
  • Create a single database that contains a container for order and a container for order items.

  Reveal Answer Answer: B Next Question

• Question 4

  

  You are implementing an Azure Data Factory data flow that will use an Azure Cosmos DB (SQL API) 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?

  • Throughput
  • Write throughput budget
  • Batch size
  • Collection action

  Reveal Answer Answer: C Next Question

• Question 5

  

  You are troubleshooting the current issues caused by the application updates.Which action can address the application updates issue without affecting the functionality of the application?

  • Enable time to live for the con-product container.
  • Set the default consistency level of account1 to strong.
  • Set the default consistency level of account1 to bounded staleness.
  • Add a custom indexing policy to the con-product container.

  Reveal Answer Answer: C Next Question

• Question 6

  

  You plan to create an Azure Cosmos DB account that will use the NoSQL API.You need to create a grouping strategy for items that will be stored in the account. The solution must ensure that write and read operations on the items can be performed within the same transact!What should you use to group the items?

  • logical partitions
  • physical partitions
  • databases
  • containers

  Reveal Answer Answer: A Next Question

• Question 7

  

  You have a database in an Azure Cosmos DB for NoSQL account. The database contains a container named container1. The indexing mode container1 is set to none. You configure Azure Cognitive Search to extract data from container1 and make the data searchable. You discover that the Cognitive Search index is missing all the data from the Azure Cosmos DB index. What should you do to resolve the issue?

  • Modify The index attributes in Cognitive Search to searchable.
  • Modify the index attributes in Cognitive Search to Retrievable.
  • Change the indexing mode of container 1 to consistent-
  • Modify the indexing policy of container 1 to exclude the / * path

  Reveal Answer Answer: C Next Question

• Question 8

  

  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.

  • 'connector.class': 'com.azure.cosmos.kafka.connect.source.CosmosDBSourceConnector'
  • 'key.converter': 'org.apache.kafka.connect.json.JsonConverter'
  • 'key.converter': 'io.confluent.connect.avro.AvroConverter'
  • 'connect.cosmos.containers.topicmap': 'iot#telemetry'
  • 'connect.cosmos.containers.topicmap': 'iot'
  • 'connector.class': 'com.azure.cosmos.kafka.connect.source.CosmosDBSinkConnector'

  Reveal Answer Answer: C, D, F Next Question

• Question 9

  

  You need to implement a trigger in Azure Cosmos DB Core (SQL) API that will run before an item is inserted into a container.Which two actions should you perform to ensure that the trigger runs? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

  • Append pre to the name of the JavaScript function trigger.
  • For each create request, set the access condition in RequestOptions.
  • Register the trigger as a pre-trigger.
  • For each create request, set the consistency level to session in RequestOptions.
  • For each create request, set the trigger name in RequestOptions.

  Reveal Answer Answer: C Next Question

• Question 10

  

  You have an Azure Cosmos DB Core (SQL) API account.You configure the diagnostic settings to send all log information to a Log Analytics workspace.You need to identify when the provisioned request units per second (RU/s) for resources within the account were modified.You write the following query.AzureDiagnostics| where Category == 'ControlPlaneRequests'What should you include in the query?

  • | where OperationName startswith 'AccountUpdateStart'
  • | where OperationName startswith 'SqlContainersDelete'
  • | where OperationName startswith 'MongoCollectionsThroughputUpdate'
  • | where OperationName startswith 'SqlContainersThroughputUpdate'

  Reveal Answer Answer: A Next Question

Page: 1 / 21
Total Questions: 102

Previous Page Next Page