Badge

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.

Required exams: Exam DP-200 and Exam DP-201

Optional prerequisite: 1 exam | See details

Skills measured

Effective June 21, 2019, the exams for this certification have been refocused.

Exam DP-200 has been refocused to differentiate the data engineer from a database administrator, emphasizing the data engineer’s proficiency in implementing solutions for data storage in varying forms, structures, and purpose. For more information on the updated content areas, see Exam DP-200.

Exam DP-201 has been refocused to differentiate the data engineer from a database administrator, emphasizing the data engineer’s proficiency in designing solutions for data storage in varying forms, structures, and purpose. For more information on the updated content areas, see Exam DP-201.

Implement data storage solutions

Implement non-relational data stores

  • implement a solution that uses Cosmos DB, Data Lake Storage Gen2, or Blob storage
  • implement data distribution and partitions
  • implement a consistency model in CosmosDB
  • provision a non-relational data store
  • provide access to data to meet security requirements
  • implement for high availability, disaster recovery, and global distribution

Implement relational data stores

  • configure elastic pools
  • configure geo-replication
  • provide access to data to meet security requirements
  • implement for high availability, disaster recovery, and global distribution
  • implement data distribution and partitions for SQL Data Warehouse
  • Implement PolyBase

Manage data security

  • implement data masking
  • encrypt data at rest and in motion

Manage and develop data processing

Develop batch processing solutions

  • develop batch processing solutions by using Data Factory and Azure Databricks
  • ingest data by using PolyBase
  • implement the integration runtime for Data Factory
  • create linked services and datasets
  • create pipelines and activities
  • create and schedule triggers
  • implement Azure Databricks clusters, notebooks, jobs, and autoscaling
  • ingest data into Azure Databricks

Develop streaming solutions

  • configure input and output
  • select the appropriate windowing functions
  • implement event processing using Stream Analytics

Monitor and optimize data solutions

Monitor data storage

  • monitor relational and non-relational data sources
  • implement BLOB storage monitoring
  • implement Data Lake Store monitoring
  • implement SQL Database monitoring
  • implement SQL Data Warehouse monitoring
  • implement Cosmos DB monitoring
  • configure Azure Monitor alerts
  • implement auditing by using Azure Log Analytics

Monitor data processing

  • design and implement Data Factory monitoring
  • monitor Azure Databricks
  • monitor HDInsight processing
  • monitor stream analytics

Optimize Azure data solutions

  • troubleshoot data partitioning bottlenecks
  • optimize Data Lake Storage
  • optimize Stream Analytics
  • optimize SQL Data Warehouse
  • optimize SQL Database
  • manage data life cycle

Design Azure data storage solutions

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

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

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

Optional prerequisite

A helpful starting point for individuals just starting in technology or thinking about a career change.

Microsoft Certified: Azure Fundamentals

Prove that you understand cloud concepts, core Azure Services, Azure pricing and support, and the fundamentals of cloud security, privacy, compliance and trust.

Prepare for certification

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

Exam DP-200

Exam DP-200: Implementing an Azure Data Solution

Languages: English

This exam measures your ability to accomplish the following technical tasks: implement data storage solutions; manage and develop data processing; and monitor and optimize data solutions. Learn more.

Schedule exam

Exam DP-201

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. Learn more.

Schedule exam

*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

Training guide

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

Guides to Training and Certifications

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

Exam Replay

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