DP-200 Certificate Study Guide

Exam DP-200 Implementing an Azure Data Solution

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 Certificate Study Guide.

Also, please share the post within your circles so it helps them to prepare for the exam.

 

Some Practice tests from Amazon:

Amazon India Exam DP-200: Azure Data Engineer Associate 91 Test Prep Questions
Other countries Exam DP-200 & DP-201: Azure Data Engineer Associate 91 Test Prep Questions

 

Practice Tests:

Udemy DP-200 Implementing an Azure Data Solution Exam Q&A
Pluralsight (see Skills IQs that tests for different data skills) Building, Monitoring, Managing, Securing Azure Data Solutions

 

To view other Azure certificate study guides, click here

 

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

 

Here you go!

 

DP-200 – Implement Data Storage Solutions

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#create-an-azure-cosmos-account

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#creating-a-new-sql-database-elastic-pool-using-the-azure-portal

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#load-the-data-into-your-data-warehouse

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

 

 

DP-200 – Manage and Develop Data Processing

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#create-a-linked-service

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

Create pipelines and activities

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

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

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

 

DP-200 – Monitor and Optimize Data Solutions

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

 

 

That’s it! This completes the DP-200 Certification Study Guide! 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

7 Comments

Leave a Reply

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