DP-200 Study Guide

DP-200 Implementing Azure Data Solutions Study Guide

Preparing for DP-200 Implementing an Azure Data Solution exam? Don’t know where to start? This post is the DP-200 Certificate Study Guide (with links to each exam objective).

I have curated a list of articles from Microsoft documentation for each objective of DP-200 exam. I hope this article will be your DP-200 Study Guide. Also, please share the post within your circles so it helps them to prepare for the exam.

 

DP-200 Practice Tests

Udemy Practice TestsDP-200 Microsoft Implementing an Azure data exam
Whizlabs Practice Tests3 Practice Tests (165 Questions) Coming Soon

 

To view DP-201 Study Guide, click here. To view other Azure certificate study guides, click here

Full disclosure: Some of the links in this post are affiliate links. I receive some commission if you purchase through them. This way you can support my blog at not extra cost to you!

 

Implement Data Storage Solutions (40-45%)

Implement Non-relational Data Stores

Implement a solution that uses Cosmos DB

https://docs.microsoft.com/en-us/azure/cosmos-db/sql-api-dotnet-application

Implement a solution that uses Blob storage

https://docs.microsoft.com/en-us/azure/storage/blobs/storage-blob-static-website-host

Implement a solution that uses Data Lake Storage Gen2

https://docs.microsoft.com/en-us/azure/data-factory/load-azure-data-lake-storage-gen2

Implement data distribution

https://docs.microsoft.com/en-us/azure/cosmos-db/distribute-data-globally

Implement data partitions

https://docs.microsoft.com/en-us/azure/cosmos-db/partition-data

Implement a consistency model in CosmosDB

https://docs.microsoft.com/en-us/azure/cosmos-db/consistency-levels-choosing

Provision a non-relational data store

https://docs.microsoft.com/en-us/azure/cosmos-db/create-cosmosdb-resources-portal

Provide access to data to meet security requirements

https://docs.microsoft.com/en-us/azure/cosmos-db/secure-access-to-data

Implement for high availability

https://docs.microsoft.com/en-us/azure/cosmos-db/tutorial-global-distribution-sql-api

Implement for disaster recovery

https://docs.microsoft.com/en-us/azure/cosmos-db/online-backup-and-restore

Implement for global distribution

https://docs.microsoft.com/en-us/azure/cosmos-db/tutorial-global-distribution-sql-api

 

Implement Relational Data Stores (Course)

Configure elastic pools

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool-manage

Configure geo-replication

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-active-geo-replication-portal

Provide access to data to meet security requirements

https://docs.microsoft.com/bs-latn-ba/azure/sql-database/sql-database-security-tutorial

Implement for high availability

Configuring Resilient Azure Databases High Availability (Check with free trial)

Implement for disaster recovery

Design Disaster Recovery Strategy on Azure (Check the Data Strategies for Disaster Recovery module with a free trial)

Implement for global distribution

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-implement-geo-distributed-database

Implement data partitions for SQL Data Warehouse

https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-tables-partition

Implement data distribution for SQL Data Warehouse

https://docs.microsoft.com/en-us/azure/sql-data-warehouse/load-data-from-azure-blob-storage-using-polybase

Implement PolyBase

https://docs.microsoft.com/en-us/azure/sql-data-warehouse/load-data-wideworldimportersdw

 

Manage Data Security (Course)

Implement data masking

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-dynamic-data-masking-get-started-portal

Encrypt data at rest

https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-encryption-tde

Encrypt data in motion

https://docs.microsoft.com/en-us/azure/vpn-gateway/vpn-gateway-howto-site-to-site-resource-manager-portal

Manage and Develop Data Processing (25-30%)

Develop Batch Processing Solutions (Course)

Develop batch processing solutions by using Data Factory and Azure Databricks

Batch processing with data factory and data bricks

Ingest data by using PolyBase

Develop batch processing with polybase

Implement the integration runtime for Data Factory

https://docs.microsoft.com/en-us/azure/data-factory/create-azure-integration-runtime

Check this video for Azure SSIS Integration Runtime – demo

Create linked services and datasets

https://docs.microsoft.com/en-us/azure/data-factory/quickstart-create-data-factory-powershell

https://docs.microsoft.com/en-us/azure/data-factory/quickstart-create-data-factory-powershell

Create pipelines and activities

https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipelines-activities

https://docs.microsoft.com/en-us/azure/data-factory/quickstart-create-data-factory-powershell

Create and schedule triggers

Create Schedule Trigggers in Azure Data Factory

Implement Azure Databricks clusters, notebooks, jobs, and autoscaling

Azure Databricks Cluster, Notebooks, Jobs

https://docs.azuredatabricks.net/user-guide/clusters/sizing.html

Ingest data into Azure Databricks

https://docs.microsoft.com/en-us/azure/azure-databricks/databricks-extract-load-sql-data-warehouse

 

Develop Streaming Solutions

Configure input and output

https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-define-inputs

https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-documentdb-output

Select the appropriate windowing functions

https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-window-functions

Implement event processing using Stream Analytics

Check the modue ‘Understanding Complex Event Processing and Azure Stream Analytics’ – Driving game scenario

 

Monitor and Optimize Data Solutions (30-35%)

Monitor Data Storage (Course)

Monitor relational and non-relational data sources

Microsoft Azure Database Monitoring Playbook

Implement BLOB storage monitoring

https://docs.microsoft.com/en-us/azure/storage/common/storage-monitor-storage-account

Monitoring Azure Data Lake Store (Check the module ‘Implementing Azure Storage and Azure Data Lake Storage Monitoring’)

Implement Data Lake Store monitoring

https://docs.microsoft.com/en-us/azure/data-lake-store/data-lake-store-diagnostic-logs

Monitoring Azure Data Lake Store (Check the module ‘Implementing Azure Storage and Azure Data Lake Storage Monitoring’)

Implement SQL Database monitoring

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-monitor-tune-overview

Implement SQL Data Warehouse monitoring

https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-monitor-workload-portal

Implement Cosmos DB monitoring

https://docs.microsoft.com/en-us/azure/cosmos-db/monitor-accounts

Configure Azure Monitor alerts

https://docs.microsoft.com/en-us/azure/azure-monitor/platform/alerts-metric

Implement auditing by using Azure Log Analytics

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-auditing

 

Monitor Data Processing (Course)

Design and implement Data Factory monitoring

https://docs.microsoft.com/en-us/azure/data-factory/monitor-using-azure-monitor

Monitor Azure Databricks

https://docs.microsoft.com/en-us/azure/data-factory/monitor-using-azure-monitor

Monitor HDInsight processing

https://docs.microsoft.com/en-us/azure/data-factory/monitor-using-azure-monitor

Monitor stream analytics

https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-monitor-and-manage-jobs-use-powershell

 

Optimize Azure Data Solutions (Course)

Troubleshoot data partitioning bottlenecks

https://docs.microsoft.com/en-us/azure/architecture/best-practices/data-partitioning-strategies

https://docs.microsoft.com/en-us/azure/architecture/best-practices/data-partitioning-strategies

Optimize Data Lake Storage

https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-performance-tuning-guidance

Optimize Stream Analytics

https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-parallelization

Optimize SQL Data Warehouse

https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-best-practices

Optimize SQL Database

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-monitor-tune-overview

Manage data life cycle

https://docs.microsoft.com/en-us/azure/storage/blobs/storage-lifecycle-management-concepts

That’s it! This completes the DP-200 Certification Study Guide!

What do you think? Let me know in the Comments section if I have missed out on anything. Also, I love to hear from you how your preparation is going on!

In case you are looking for other Azure certification exams check out this page

Want to be notified as soon as I post? Subscribe to RSS feed / leave your email address in the subscribe section. Share the article to your social networks with the below links so it can benefit others.

  •  
  •  
  •  
  •  
  •  

You may also like

8 Comments

Leave a Reply

Your e-mail address will not be published. Required fields are marked *