Open more doors with role-based certification. Certify with Confidence offers you more chances to pass.

Exam
DP-200

Microsoft Azure

Implementing an Azure Data Solution (beta)

  • Image of Azure associate badge

    Part of requirements for Microsoft Certified: Azure Data Engineer Associate

    With Microsoft Certification, technology professionals are more likely to get hired, demonstrate clear business impact, and advance their careers.

    About the certification
* 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.

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.

Implement Data Storage Solutions (25-30%)
  • Implement Azure cloud data warehouses
    • May include but is not limited to: Design Data Lake architecture, design the data schema, provision the data warehouse
  • Implement No-SQL Databases
    • May include but is not limited to: Manage Data distribution and Partitions, select the database platform, model data storage based on use cases, select storage types, provision storage accounts, provision Data Lake storage, integrate WebHDFS applications with Data Lake Storage, provision in CosmosDB
  • Implement Azure SQL Database
    • May include but is not limited to: Provision Azure SQL Database, configure elastic pools, configure data backup strategies, configure elastic jobs, provision Azure SQL database managed instance, configure connections, manage data synchronization
  • Implement hybrid data scenarios
    • May include but is not limited to: Design hybrid solution, design data replication and synchronization
  • Manage Azure DevOps Pipelines
    • May include but is not limited to: Use a build service, deploy using Azure Resource Manager templates
Manage and Develop Data Processing (30-35%)
  • Implement big data environments
    • May include but is not limited to: Implement Hadoop clusters, implement Databricks environment
  • Develop batch processing solutions
    • May include but is not limited to: Develop batch processing solutions using Spark, develop batch processing solutions using Azure Databricks
  • Develop streaming solutions
    • May include but is not limited to: Implement event processing using Azure stream analytics, query data using Azure Stream Analytics, configure Azure Stream Analytics to read from Event Hub, configure Azure Stream Analytics to read from BLOB storage
  • Develop integration solutions
    • May include but is not limited to: Create data pipeline systems in Azure, develop data integration pipelines with Azure Data Factory, develop data integration pipelines with Azure Databricks
  • Implement data migration
    • May include but is not limited to: Transform data, bulk load data with PolyBase
  • Automate Data Factory Pipelines
    • May include but is not limited to: Deploy data factory pipelines, configure Data Factory
Manage Data Security (15-20%)
  • Manage source data access security
    • May include but is not limited to: Connect to sources, create connection objects, install Gateways
  • Configure authentication and authorization
    • May include but is not limited to: Set up firewall rules, integrate Azure AD, design Cosmos DB security, design Data Lake security, design Azure SQL DB security, manage Access Control, manage permissions on resources
  • Manage and enforce data policies and standards
    • May include but is not limited to: Mask data, encrypt data at rest, encrypt data in motion, encrypt data elements, configure audit
  • Set up notifications
    • May include but is not limited to: Set up alerts on security threats, set up alerts on unexpected resource usage
Monitoring Data Solutions (10-15%)
  • Monitor data storage
    • May include but is not limited to: Implement BLOB storage monitoring, implement Data Lake Store monitoring, implement HDInsight monitoring
  • Monitor databases for a specified scenario
    • May include but is not limited to: Implement SQL Database monitoring, implement SQL Data Warehouse monitoring, implement Cosmos DB monitoring
  • Monitor data processing
    • May include but is not limited to: Design and implement Data Factory monitoring, monitor Azure Databricks, monitor HDInsight processing, monitor stream analytics
Manage and Troubleshoot Azure Data Solutions (10-15%)
  • Manage Optimization
    • May include but is not limited to: Troubleshoot data partitioning bottlenecks, optimize HIVE processing, optimize Data Lake, optimize SPARK processing, optimize Azure Stream Analytics, optimize Data Warehouse, optimize SQL DB, manage data life cycle
  • Manage business continuity
    • May include but is not limited to: Implement a disaster recovery strategy, design for High Availability, Import and export data, design a data retention policy

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.

More information about exams


Preparing for an exam

We recommend that you review this exam preparation guide in its entirety and familiarize yourself with the resources on this website before you schedule your exam. See the Microsoft Certification exam overview for information about registration, videos of typical exam question formats, and other preparation resources. For information on exam policies and scoring, see the Microsoft Certification exam policies and FAQs.


Note

This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format. To help you prepare for this exam, Microsoft recommends that you have hands-on experience with the product and that you use the specified training resources. These training resources do not necessarily cover all topics listed in the "Skills measured" section.