DP 203: Data Engineering on Microsoft Azure Volume 1 – First Edition

About Microsoft Certified: Microsoft Azure Data Engineer Associate

The Microsoft Certified: 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.

This exam measures your ability to accomplish the following technical tasks:

1. Design and implement data storage (40-45%)
2. Design and develop data processing (25-30%)
3. Design and implement data security (10-15%)
4. Monitor and optimize data storage and data processing (10-15%)

Recommended Knowledge

1. Design a data storage structure
2. Design a partition strategy
3. Design the serving layer
4. Implement physical data storage structures
5. Implement logical data structures
6. Implement the serving layer
7. Ingest and transform data
8. Design and develop a batch processing solution
9. Design and develop a stream processing solution
10. Manage batches and pipelines
11. Design security for data policies and standards
12. Implement data security
13. Monitor data storage and data processing
14. Optimize and troubleshoot data storage and data processing

All the required information is included in this technology workbook.