DP-200 (Implementing Azure Data Solution) Exam 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 Course (Online Training)

 

DP-200 Practice Tests & Lab

Whizlabs (Try Sample questions)3 Practice Tests (a total of 165 Questions)
Udemy Practice TestsImplementing an Azure data exam
GitHub Labs on DP-200Labs in GitHub

 

DP-200 E-book (PDF)

AmazonAzure Data Engineer 56 Digital Flash Cards

 

DP-200 Exam Voucher

Test VoucherMicrosoft Azure Single Shot Exam Voucher ($30 OFF)

 

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 a commission when you purchase through them.

 

Looking for DP-200 dumps? Read this!

Using dp-200 exam dumps can get you permanently banned from taking any future Microsoft certificate exam. Read the FAQ page for more information. However, I strongly suggest you validate your understanding with practice questions.

 

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

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

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

Amazon link (affiliate)

Manage and Develop Data Processing (25-30%)

Develop Batch Processing Solutions

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

Check the FAQs on Azure Certification

Monitor and Optimize Data Solutions (30-35%)

Monitor Data Storage

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

Amazon link (affiliate)

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

Sign up for Newsletter

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

10 Comments

  1. In some modules you have given course link. So does that mean either of those course or links mentioned in that module are sufficient? Or all of those should be covered?

    1. The links are courses that closely cover the topics. Use that as a way to gain a broader understanding of topics. But it should not be considered sufficient. Refer docs as well

Leave a Reply

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