Badge

Exam DP-201: Designing an Azure Data Solution

Candidates for this exam are Microsoft Azure data engineers who collaborate with business stakeholders to identify and meet the data requirements to design data solutions that use Azure data services....

Azure data engineers are responsible for data-related tasks that include designing Azure data storage solutions that use relational and non-relational data stores, batch and real-time data processing solutions, and data security and compliance solutions.

Candidates for this exam must design data solutions that use the following Azure services: Azure Cosmos DB, Azure SQL Database, Azure SQL Data Warehouse, Azure Data Lake Storage, Azure Data Factory, Azure Stream Analytics, Azure Databricks, and Azure Blob storage.

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; and design for data security and compliance.

Schedule exam

Skills measured

Design Azure data storage solutions (40-45%)

Recommend an Azure Data solution based on requirements

  • choose the correct data storage solution to meet the technical and business requirements
  • choose the partition distribution type

Design non-relational cloud data stores

  • design data distribution and partitions
  • design for scale, including multi-region, latency, and throughput
  • design a solution that uses Cosmos DB, Data Lake Storage Gen2, or Blob storage
  • select the appropriate Cosmos DB API
  • design a disaster recovery strategy
  • design for high availability

Design relational cloud data stores

  • design data distribution and partitions
  • design for scale, including multi-region, latency, and throughput
  • design a solution that uses SQL Database and SQL Data Warehouse
  • design a disaster recovery strategy
  • design for high availability

Design data processing solutions (25-30%)

Design batch processing solutions

  • design batch processing solutions by using Data Factory and Azure Databricks
  • identify the optimal data ingestion method for a batch processing solution
  • identify where processing should take place, such as at the source, at the destination, or in transit

Design real-time processing solutions

  • design for real-time processing by using Stream Analytics and Azure Databricks
  • design and provision compute resources

Design for data security and compliance (25-30%)

Design security for source data access

  • plan for secure endpoints
  • choose the appropriate authentication mechanism, such as access keys, shared access signatures (SAS), and Azure Active Directory (Azure AD)

Design security for data policies and standards

  • design for data encryption for data at rest and in transit
  • design for data auditing and data masking
  • design for data privacy and data classification
  • design a data retention policy
  • plan an archiving strategy
  • plan to purge data based on business requirements

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 Training and Certifications

Explore all certifications in a concise training and certifications guide or the Training and Certifications poster.

Training guide

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

Exam Replay

See two great offers to help boost your odds of success.

Support for certification exams

Get help through Microsoft Certification support forums. A forum moderator will respond in one business day.