DP-420

Microsoft DP-420 practice exams

240 questions in 5 timed practice tests. Each test has about 51 questions and a 100-minute limit. The pass mark is 70%. Results are split across the 3 exam domains.

Exam at a glance

DP-420 practice exam settings
Practice tests 5
Questions in total 240
Questions per test About 51
Time limit per test 100 minutes
Pass mark 70%
Question types Single answer and multiple answer (22 multiple-answer questions)
Level Specialty
Category Cloud

These are the settings of our practice tests. Check the official Microsoft exam page for the current exam format before you book.

Domains and weights

DP-420 exam domains, weights and question counts
Domain Weight Weight bar Questions in our bank
Design and develop database solutions 44% 104
Secure, optimize, and deploy database solutions 33% 80
Implement AI and analytics capabilities in database solutions 23% 56

Sample questions

Question 1 of 3

An IoT container is partitioned by /deviceId. A few very chatty devices send most of the writes, and Normalized RU Consumption shows one physical partition at 100% while the others stay low. The team must keep point reads by device and time window efficient. Which partition key change is MOST appropriate?

  1. A Use /readingType as the key because there are only five reading types and each is evenly used
  2. B Use a synthetic key that combines deviceId with the reading date, such as device42-2026-11-08 (correct answer)
  3. C Keep /deviceId and increase the container throughput until the hot partition stops throttling
  4. D Use /readingType as the partition key because there are only five reading types and each is evenly used
Why: A synthetic key of deviceId plus date spreads a chatty device's writes across many logical partitions, and readers can still compute the key for a device and date to do targeted reads. A five-value key has very low cardinality and creates even hotter partitions. Partitioning by id spreads writes but makes reads by device a fan-out query. Raising throughput divides it evenly across physical partitions, so the hot partition gets only a fraction of the increase.

Question 2 of 3

An event log container uses the event date in yyyy-MM-dd format as its partition key. Writes keep slowing down with 429 errors even after throughput increases, while most physical partitions are nearly idle. What is the root cause and the BEST fix?

  1. A All writes for the current day hit one logical partition; use a key such as sourceId or a date plus a hash suffix (correct answer)
  2. B The container has too few physical partitions; split the container manually into more physical partitions
  3. C The account uses session consistency; switch to eventual consistency so that writes are acknowledged faster
  4. D The indexing policy is too large; exclude all paths so that each write costs far fewer request units than before
Why: A date key concentrates every write of the day in one logical partition and therefore one physical partition, so extra throughput spread across partitions does not help; a higher-cardinality key or synthetic suffix spreads the load. Physical partitions are managed by the service, and more of them would not move today's partition. Excluding all paths lowers write cost but breaks queries and leaves the hot spot. Consistency does not change write distribution.

Question 3 of 3

A container holds customers, orders and invoices with a type discriminator, partitioned by /customerId. Throughput is shared across all entity types, and most requests read a customer with their recent orders. A colleague proposes moving each entity type into its own container. What is the MAIN downside of that proposal?

  1. A Transactional batches would get faster because each container holds fewer items
  2. B Each container could hold only one type of document, so the type discriminator property would have to be removed
  3. C Change feed processors could no longer read the separate containers because they would have different schemas
  4. D Reading a customer with its orders would need requests to several containers instead of one query (correct answer)
Why: Co-locating related entity types in one container with the same partition key lets the app fetch a customer and recent orders in one single-partition query and update them in one transactional batch; splitting them adds requests and removes that transaction scope. Containers are schema-agnostic, so a discriminator is still possible. Batches cannot span containers, so they would not become faster. Change feed works on any container regardless of schema.

What your score report looks like

Example attempt, DP-420 practice test 3

83%

Passed
Pass mark 70%

Score by exam domain
DomainWeightYour score%
Design and develop database solutions 44%
88
Secure, optimize, and deploy database solutions 33%
81
Implement AI and analytics capabilities in database solutions 23%
76

Study next: Implement AI and analytics capabilities in database solutions. It is below the pass mark and carries 23% of the exam.

Domains and pass mark from our DP-420 practice tests. Scores are an example attempt.

Study plans

Two weeks

  1. Day 1: take practice test 1 in exam mode to get a baseline.
  2. Days 2 to 5: domain mode on Design and develop database solutions and Secure, optimize, and deploy database solutions, the two most heavily weighted domains.
  3. Day 6: practice test 2 in exam mode, then the mistakes quiz.
  4. Days 7 to 12: practice tests 3 to 5, one every other day, each followed by its mistakes quiz.
  5. Days 13 and 14: final mode. Book the exam when your readiness stays above the pass mark.

Four weeks

  1. Week 1: one practice test in practice mode, reading every explanation. Note your two lowest domains.
  2. Week 2: domain mode on those two domains, then a second practice test in exam mode.
  3. Week 3: practice tests 3 and 4 in exam mode, with the mistakes and flagged quizzes after each.
  4. Week 4: practice test 5 and final mode until your readiness holds above the pass mark.

Questions about the DP-420 practice exams

Are these real DP-420 exam questions?
No. We write every question ourselves and map it to the published DP-420 exam objectives. We do not use leaked or recalled questions.
Do the time limit and pass mark match the official exam?
They match the settings of our practice tests. Exam providers change their format from time to time, so check the official exam page before you book.
Can I try it before I pay?
Yes. The free mini exam has 15 questions with full explanations and needs no account.
How long do I keep access?
A single-exam purchase gives you 12 months of access. All-Access includes this exam for as long as your subscription runs.
What happens after I finish a test?
You get a score, a pass or fail against the pass mark, a score per domain and every answer with its explanation.

Last updated November 2026. Written and reviewed by the DevOpsCode Lab team.

DevOpsCode Lab is not affiliated with Microsoft. DP-420 and related names are trademarks of their owners.

Related exams
Exam Vendor Level Questions Minutes Price
AZ-400Microsoft DevOps AZ-400 Microsoft Expert 250 100 $14.99
MO-111Word Expert MO-111 Microsoft Expert 300 60 $14.99
MO-211Excel Expert MO-211 Microsoft Expert 300 60 $14.99
MS-102Microsoft 365 MS-102 Microsoft Expert 250 100 $14.99
AB-731AI Transformation Leader AB-731 Microsoft Foundational 250 100 $9.99
AB-900Copilot & Agent Admin AB-900 Microsoft Foundational 225 45 $9.99