Learning Path Microsoft DP-203
Candidates for this exam should have subject matter expertise integrating, transforming, and consolidating data from various structured and unstructured data systems into a structure that is suitable for building analytics solutions.
Azure data engineers help stakeholders understand the data through exploration, and they build and maintain secure and compliant data processing pipelines by using different tools and techniques. These professionals use various Azure data services and languages to store and produce cleansed and enhanced datasets for analysis.
Azure data engineers also help ensure that data pipelines and data stores are high-performing, efficient, organized, and reliable, given a set of business requirements and constraints. They deal with unanticipated issues swiftly, and they minimize data loss. They also design, implement, monitor, and optimize data platforms to meet the data pipelines needs.
A candidate for this exam must have strong knowledge of data processing languages such as SQL, Python, or Scala, and they need to understand parallel processing and data architecture patterns.
You may be eligible for ACE college credit if you pass this certification exam. See ACE college credit for certification exams for details.
Exam details on the Microsoft website can be found HERE.
Skills measured:
- Design and implement data storage (40-45%)
- Design and develop data processing (25-30%)
- Design and implement data security (10-15%)
- Monitor and optimize data storage and data processing (10-15%)
Design and implement data storage (40-45%)
Suggested training materials
Course: Microsoft DP-203 – Data Engineering on Microsoft Azure
- Link to entire course
- Link to Module 1 Explore compute and storage options for data engineering workloads
- Link to Module 2 Design and Implement the serving layer
- Link to Module 3 Data engineering considerations for source files
- Link to Module 4 Run interactive queries using serverless SQL pools
Design and develop data processing (25-30%)
Suggested training materials
Course: Microsoft DP-203 – Data Engineering on Microsoft Azure
- Link to entire course
- Link to Module 5 Explore, transform, and load data into the Data Warehouse using Apache Spark
- Link to Module 6 Data Exploration and Transformation in Azure Databricks
- Link to Module 7 Ingest and load Data into the Data Warehouse
- Link to Module 8 Transform Data with Azure Data Factory or Azure Synapse Pipelines
Design and implement data security (10-15%)
Suggested training materials
Course: Microsoft DP-203 – Data Engineering on Microsoft Azure
- Link to entire course
- Link to Module 9 Integrate Data from Notebooks with Azure Data Factory or Azure Synapse Pipelines
- Link to Module 10 Optimize Query Performance with Dedicated SQL Pools in Azure Synapse
- Link to Module 11 Analyze and Optimize Data Warehouse Storage
- Link to Module 12 Support Hybrid Transactional Analytical Processing (HTAP) with Azure Synapse Link
Monitor and optimize data storage and data processing (10-15%)
Suggested training materials
Course: Microsoft DP-203 – Data Engineering on Microsoft Azure
- Link to entire course
- Link to Module 13 End-to-end security with Azure Synapse Analytics
- Link to Module 14 Real-time Stream Processing with Stream Analytics
- Link to Module 15 Create a Stream Processing Solution with Event Hubs and Azure Databricks
- Link to Module 16 Build reports using Power BI integration with Azure Synpase Analytics
- Link to Module 17 Perform Integrated Machine Learning Processes in Azure Synapse Analytics
Practice Exams Microsoft DP-203