DP-201 Designing an Azure Data Solution (beta)

Languages: English
Audiences: IT Professionals
Technology: Microsoft Azure

Skills measured
This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam. View video tutorials about the variety of question types on Microsoft exams.

Do you have feedback about the relevance of the skills measured on this exam? Please send Microsoft your comments. All feedback will be reviewed and incorporated as appropriate while still maintaining the validity and reliability of the certification process. Note that Microsoft will not respond directly to your feedback. We appreciate your input in ensuring the quality of the Microsoft Certification program.

If you have concerns about specific questions on this exam, please submit an exam challenge.

If you have other questions or feedback about Microsoft Certification exams or about the certification program, registration, or promotions, please contact your Regional Service Center.

Design Azure Data Storage Solutions (30-35%)
Design an Azure Data solution
May include but is not limited to: 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
May include but is not limited to: Design the data schema, design for scale
Design No-SQL Databases
May include but is not limited to: 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
May include but is not limited to: Design for scale, design data load technologies, design solution architecture
Design hybrid data scenarios
May include but is not limited to: Design hybrid solution, design data replication and synchronization

Design Data Processing Solutions (25-30%)
Design batch processing solutions
May include but is not limited to: Design batch processing solutions using Spark, design batch processing solutions using Azure Databricks
Design big data real-time processing solutions
May include but is not limited to: Design for real-time processing, design for LAMBDA architecture, design and provision compute resources
Design integration solutions
May include but is not limited to: Design cloud analytic solutions, design data processing activities, design data migration

Design for Data Security and Compliance (15-20%)
Design source data access security
May include but is not limited to: Design network security, choose the appropriate authentication mechanism, choose the appropriate authorization mechanism
Design security for data policies and standards
May include but is not limited to: Design for data encryption, design for data auditing, design for data privacy
Design a data retention policy
May include but is not limited to: Design a backup and recovery policy, evaluate business requirements for data retention

Design for High Availability and Disaster Recovery (20-25%)
Design for Optimization
May include but is not limited to: 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
May include but is not limited to: 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
May include but is not limited to: Design for multi-region availability, design for read scale, design for multi-master writes

Preparation options
Find classroom and online training
Explore more training on Microsoft Learn

Who should take this exam?
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.