DP-200: Exam Voucher PR

Exam DP-200: Implementing an Azure Data Solution

Candidates for this exam are Microsoft Azure data engineers who collaborate with business stakeholders to identify and meet the data requirements to implement data solutions that use Azure data services.

Azure data engineers are responsible for data-related tasks that include provisioning data storage services, ingesting streaming and batch data, transforming data, implementing security requirements, implementing data retention policies, identifying performance bottlenecks, and accessing external data sources.

Candidates for this exam must be able to implement data solutions that use the following Azure services: Azure Cosmos DB, Azure SQL Database, Azure SQL Data Warehouse, Azure Data Lake Storage, Azure Data Factory, Azure Stream Analytics, Azure Databricks, and Azure Blob storage.

Exam duration: 180 minutes

Number of questions: between 40 and 60

Minimum passing score: 700


Exam DP-200:  Skills Measured

Implement data storage solutions (40-45%)

  •  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 (25-30%)

  •   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 (30-35%)

  •   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