DP-200 Exam Study Guide (Implementing Azure Data Solution)

DP-200: Implementing an Azure Data Solutions Certificate Exam Study Guide

Preparing for the 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 the DP-200 exam. Please share the post within your circles so it helps them to prepare for the exam.

DP-200 Data Solution Course (Online Training)

DP-200 Data Solution Practice Test & Lab

Whizlabs Practice Test3 Practice Tests (165 Questions)
Udemy Practice TestsImplementing an Azure data exam
GitHub Labs on DP-200Labs to practice from GitHub

DP-200 Azure Data Solution E-book (PDF)

AmazonAzure Data Engineer: Data WH & Data Factory

DP-200 Sample Practice Exam Questions

To view the 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 Azure Synapse Analytics

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

Implement data distribution for Azure Synapse Analytics

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

dp-200

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

Implement Copy Activity within Azure Data Factory

https://docs.microsoft.com/en-us/azure/data-factory/copy-activity-overview

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

Implement Mapping Data Flows in Azure Data Factory

https://docs.microsoft.com/en-us/azure/data-factory/concepts-data-flow-overview

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 Azure Synapse Analytics 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

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-insights-alerts-portal

Implement Auditing by using Azure Log Analytics

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

dp-200

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

Follow/Like ravikirans.com to receive updates

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.

Sharing is Caring

  • 7
  • 9
  • 3
  •  
  •  
    19
    Shares

You may also like

13 Comments

  1. I am going to write exam next week, any changes in the pattern and style of exam. is there any lab problem solving practical questions?

    1. Good luck with your exams. Be prepared for the labs. They may or may not be there. Sorry for the ambiguous answer, but that’s how the exams are

  2. 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 *