The “Implementing an Azure Data Solution” certification exam, coded as DP-200, is a Microsoft certification that assesses a candidate’s ability to design and implement data solutions on the Microsoft Azure cloud platform. This certification is part of Microsoft’s Data Engineer Associate certification track. Earning the DP-200 certification demonstrates your expertise in designing and implementing data solutions on Azure.
IMPLEMENTING AN AZURE DATA SOLUTION – DP 200 TRAINING IN PUNE | ONLINE
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 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
– 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
– 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 built-in functions
– implement event processing by using Stream Analytics
Monitor and Optimize Data Solutions
Monitor data storage
– 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
– 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
– troubleshoot data partitioning bottlenecks
– optimize Data Lake Storage Gen2
– optimize Stream Analytics
– optimize Azure Synapse Analytics
– manage the data lifecycle