ExamDumpster

DP-201

Designing an Azure Data Solution practice test

302 Microsoft DP-700, DP-201 and DP-203 practice questions with explanations, in study, timed and flashcard modes.

Full access

$99

  • All 302 questions across DP-700, DP-201 and DP-203, with explanations
  • Study, timed and flashcard modes
  • Progress saved, resume any time
Try the free samples first
Microsoft logo
Total questions
302
Free samples
–
Versions
3
Updated
Jan 2026

Exam simulator

Practice DP-201 in the simulator.

Study, timed and flashcard modes. Answers and explanations as you go, and your progress saves.

At a glance

DP-201, by the numbers.

Official specifications published by Microsoft.

In the bank
DP-700 (167), DP-201 (74), DP-203 (61)
Open the full exam guide

Exam guide

Everything about DP-201.

DP-201 · Microsoft

What is DP-201?

DP-201 was the design half of Microsoft's Azure Data Engineer Associate certification, taken with DP-200. Microsoft retired it in June 2021 and replaced both exams with DP-203, which DP-700 has since replaced. Data engineers took it to show they could plan storage, processing and security for data on Azure. A core choice was batch processing, which handles data in scheduled chunks, or stream processing, which handles it as it arrives. For example, you might pick Azure Data Lake Storage for raw files that analysts will query later. Questions in this practice test follow the original design objectives, so pair them with DP-700 study for today's exam.

What you'll practise

  • Choose Azure storage for relational and non-relational data, such as Azure SQL Database, Cosmos DB and Data Lake Storage.
  • Design batch processing with tools such as Azure Data Factory and Azure Databricks.
  • Design stream processing for data that arrives continuously, for example with Azure Stream Analytics.
  • Plan data security, including access control, encryption and data masking.

Requirements

  • DP-201 is retired and can no longer be booked; DP-700 is the current data engineering exam.
  • Recommended: hands-on experience with Azure data services and SQL.

Who it's for

  • Data engineers reviewing Azure data design skills before DP-700.
  • Data architects who plan storage and processing on Azure.
  • Learners working through older DP-200 and DP-201 study material.

Three ways to practise

Study mode

Work through the bank at your own pace with the answer and explanation one tap away. Flag questions, add notes, bookmark the hard ones.

Open in the simulator

Timed mode

A shuffled deck with a countdown that mirrors the real exam. Your score is saved to your attempt history.

Open in the simulator

Flashcards

Question on the front, answer on the back. Good for the last week before the exam.

Open in the simulator

DP-201 questions, answered