1. Home
  2. Microsoft
  3. DP-200 Exam Syllabus

Microsoft DP-200 Exam Topics

Microsoft DP-200 Exam Overview :

Exam Name: Implementing an Azure Data Solution
Exam Code: DP-200
Certifications: Microsoft Azure Data Engineer Associate Certification
Actual Exam Duration: 120 minutes
Expected no. of Questions in Actual Exam: 60
Exam Registration Price: $165
See Expected Questions: Microsoft DP-200 Expected Questions in Actual Exam

Microsoft DP-200 Exam Objectives :

Section Weight Objectives
Implement non-relational data stores 40-45% - implement a solution that uses Cosmos DB, Data Lake Storage Gen2, or Blob storage
- implement data distribution and partitions
- implement a consistency model in Cosmos DB
- 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 40-45% - provide access to data to meet security requirements
- implement for high availability and disaster recovery
- implement data distribution and partitions for Azure Synapse Analytics
- implement PolyBase
Manage data security 40-45% - implement data masking
- encrypt data at rest and in motion
Develop batch processing solutions 25-30% - 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 25-30% - configure input and output
- select the appropriate built-in functions
- implement event processing by using Stream Analytics
Monitor data storage 30-35% - monitor relational and non-relational data stores
- implement Blob storage monitoring
- implement Data Lake Storage Gen2 monitoring
- implement Azure Synapse Analytics monitoring
- implement Cosmos DB monitoring
- configure Azure Monitor alerts
- implement auditing by using Azure Log Analytics
Monitor data processing 30-35% - monitor Data Factory pipelines
- monitor Azure Databricks
- monitor Stream Analytics
- configure Azure Monitor alerts
- implement auditing by using Azure Log Analytics
Optimize of Azure data solutions 30-35% - troubleshoot data partitioning bottlenecks
- optimize Data Lake Storage Gen2
- optimize Stream Analytics
- optimize Azure Synapse Analytics
- manage the data lifecycle
Official Information https://www.microsoft.com/en-us/learning/exam-dp-200.aspx

Updates in the Microsoft DP-200 Exam Topics:

Microsoft DP-200 exam questions and practice test are the best ways to get fully prepared. Study4exam's trusted preparation material consists of both practice questions and practice test. To pass the actual  Azure Data Engineer Associate DP-200  exam on the first attempt, you need to put in hard work on these questions as they cover all updated  Microsoft DP-200 exam topics included in the official syllabus. Besides studying actual questions, you should take the  Microsoft DP-200 practice test for self-assessment and actual exam simulation. Revise actual exam questions and remove your mistakes with the Implementing an Azure Data Solution DP-200 exam practice test. Online and Windows-based formats of the DP-200 exam practice test are available for self-assessment.