DP-201: Designing an Azure Data Solution

Important notice!

This course (and DP-200) has been replaced by the new course DP-203 (to be relased from Microsoft in the end of April 2021):

DP-203: Data Engineering on Microsoft Azure






The students will also explore how to design data security including data access, data policies and standards. They will also design Azure data solutions which includes the optimization, availability and disaster recovery of big data, batch processing and streaming data solutions.

This course, together with DP-200, will help you prepare for the new Azure Data Engineer Associate certification.


The audience for this course is data professionals, data architects, and business intelligence professionals who want to learn about the data platform technologies that exist on Microsoft Azure.

The secondary audience for this course is individuals who develop applications that deliver content from the data platform technologies that exist on Microsoft Azure.


Successful students start this course with knowledge of cloud computing and core data concepts and professional experience with data solutions. 
Specifically completing:

Course content

Module 1: Data Platform Architecture Considerations

Core Principles of Creating Architectures
Design with Security in Mind
Performance and Scalability
Design for availability and recoverability
Design for efficiency and operations

Module 2: Azure Batch Processing Reference Architectures

Lambda architectures from a Batch Mode Perspective
Design an Enterprise BI solution in Azure
Automate enterprise BI solutions in Azure
Architect an Enterprise-grade Conversational Bot in Azure

Module 3: Azure Real-Time Reference Architectures

Lambda architectures for a Real-Time Perspective
Architect a stream processing pipeline with Azure Stream Analytics
Design a stream processing pipeline with Azure Databricks
Create an Azure IoT reference architecture

Module 4: Data Platform Security Design Considerations

Defense in Depth Security Approach
Identity Management
Infrastructure Protection
Encryption Usage
Network Level Protection
Application Security

Module 5: Designing for Resiliency and Scale

Adjust Workload Capacity by Scaling
Optimize Network Performance
Design for Optimized Storage and Database Performance
Identifying Performance Bottlenecks
Design a Highly Available Solution
Incorporate Disaster Recovery into Architectures
Design Backup and Restore strategies

Module 6: Design for Efficiency and Operations

Maximizing the Efficiency of your Cloud Environment
Use Monitoring and Analytics to Gain Operational Insights
Use Automation to Reduce Effort and Error


This course is recommended as preparation for exam DP-201.

Important notice!

Exam DP-201 (and exam DP-200) will retire 30 June 2021.
The new exam DP-203 is available from 23 February 2021, will replace the DP-200 and DP-201 exams.

To achieve the Azure Data Engineer Associate certification, you need to fulfil one of these two options:

  • Pass exam DP-201 and exam DP-200
  • Pass  exam DP-203