Open more doors with role-based certification. Certify with Confidence offers you more chances to pass.
Badge

Exam DP-201: Designing an Azure Data Solution

Candidates for this exam are Azure data engineers who are responsible for data related tasks that include ingesting, egressing, and transforming data from multiple sources using various services and tools. The... Azure data engineer collaborates with business stakeholders to identify and meet data requirements while designing and implementing the management, monitoring, security, and privacy of data using the full stack of Azure services to satisfy business needs.
More
 Less

Part of the requirements for: Microsoft Certified: Azure Data Engineer Associate

Related exam: Exam DP-200

Schedule exam

Exam DP-201: Designing an Azure Data Solution

Languages: English

This exam measures your ability to accomplish the following technical tasks: design Azure data storage solutions; design data processing solutions; design for data security and compliance; and design for high availability and disaster recovery.

Schedule exam

Skills measured

Design Azure data storage solutions (30-35%)

Design an Azure Data solution

  • choose the correct data storage solution to meet the technical and business requirements
  • calculate the storage capacity of data
  • recommend tier based on data requirements
  • decide partition distribution type

Design Azure Cloud data warehouses

  • design the data schema
  • design for scale

Design No-SQL Databases

  • design data distribution and partitions
  • design a CosmosDB solution
  • select the database platform
  • model data storage based on use cases
  • select storage types

Design Azure SQL Database

  • design for scale
  • design data load technologies
  • design solution architecture

Design hybrid data scenarios

  • design hybrid solution
  • design data replication and synchronization

Design data processing solutions (25-30%)

Design batch processing solutions

  • design batch processing solutions using Spark
  • design batch processing solutions using Azure Databricks

design big data real-time processing solutions

  • Design for real-time processing
  • design for LAMBDA architecture
  • design and provision compute resources

Design integration solutions

  • design cloud analytic solutions
  • design data processing activities
  • design data migration

Design for data security and compliance (15-20%)

Design source data access security

  • design network security
  • choose the appropriate authentication mechanism
  • choose the appropriate authorization mechanism

Design security for data policies and standards

  • design for data encryption
  • design for data auditing
  • design for data privacy

Design a data retention policy

  • design a backup and recovery policy
  • evaluate business requirements for data retention

Design for high availability and disaster recovery (20-25%)

Design for Optimization

  • design for optimized HIVE processing
  • design for optimized Data Lake
  • design for optimized SPARK processing
  • design for optimized Azure Stream Analytics
  • design for optimized Data Warehouse
  • design for optimized SQL DB
  • plan for the data life cycle

Design and implement a disaster recovery strategy

  • design a backup and recovery policy
  • design an online disaster recovery strategy
  • design for multi-region availability
  • plan for backup and restore

Design for High Availability

  • design for multi-region availability
  • design for read scale
  • design for multi-master writes

Prepare for exam

Self-paced

Free
Microlearning
Interactive
In-browser access
Start learning

Instructor-led

Paid
Personalized
In-person
On-demand
Explore courses

Guide to training

All self-paced and instructor-led courses in one comprehensive guide.

Download

Related certifications

Microsoft Certified: Azure Data Engineer Associate

Azure Data Engineers design and implement the management, monitoring, security, and privacy of data using the full stack of Azure data services to satisfy business needs.

* Pricing does not reflect any promotional offers or reduced pricing for Microsoft Imagine Academy program members, Microsoft Certified Trainers, and Microsoft Partner Network program members. Pricing is subject to change without notice. Pricing does not include applicable taxes. Please confirm exact pricing with the exam provider before registering to take an exam.

Additional resources

Guides to Role-based Certifications

Explore all certifications in a concise certification guide or the Role-based Certification Roadmap poster.

Training guide

Discover training resources to become a Microsoft Certified: Azure Data Engineer Associate.