DP-201 Study Guide

DP-201 Study Guide

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

I have curated a list of articles from Microsoft documentation for each objective of DP-201 exam. I hope this article will be your DP-201 Study Guide.

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

 

DP-201 Video Preparation Option

PluralsightAzure Data Solution (DP-201)

 

DP-201 Practice Tests

 

To view DP-200 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!

 

Design Azure Data Storage Solutions (40-45%)

Design data distribution and partitions

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

https://docs.microsoft.com/en-us/azure/cosmos-db/global-dist-under-the-hood

Design for scale, including multi-region, latency, and throughput

https://docs.microsoft.com/en-us/azure/cosmos-db/set-throughput

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

Check the Module ‘Tuning for throughput and performance’

Design a solution that uses Cosmos DB, Data Lake Storage Gen2, or Blob storage

https://docs.microsoft.com/en-us/azure/cosmos-db/social-media-apps

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

Select the appropriate Cosmos DB API

https://docs.microsoft.com/en-us/learn/modules/choose-api-for-cosmos-db/

Design a disaster recovery strategy

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

Design for high availability

https://docs.microsoft.com/en-us/azure/cosmos-db/high-availability

 

Design Relational Cloud Data Stores

Design data distribution and partitions

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

Design for scale, including multi-region, latency, and throughput

https://docs.microsoft.com/en-us/azure/cosmos-db/scaling-throughput

https://docs.microsoft.com/en-us/azure/cosmos-db/optimize-cost-throughput

https://docs.microsoft.com/bs-latn-ba/azure/cosmos-db/consistency-levels-tradeoffs

Design a solution that uses SQL Database and SQL Data Warehouse

Deploying Microsoft Azure SQL Data Warehouse and Azure SQL Database

Design a disaster recovery strategy

Check the Module ‘Data Strategies for Disaster Recovery’

Design for high availability

Look at the Module ‘Designing for Azure High Availability’

Design Data Processing Solutions (25-30%)

Design Batch Processing Solutions

Design batch processing solutions by using Data Factory and Azure Databricks

ETL Made Easy with Azure Data Factory and Azure Databricks Mark Kromer Microsoft

Identify the optimal data ingestion method for a batch processing solution

https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/batch-processing#technology-choices-for-batch-processing

https://docs.microsoft.com/en-us/azure/data-explorer/ingest-data-overview#choosing-the-most-appropriate-ingestion-method

Identify where processing should take place, such as at the source, at the destination, or in transit

Building Batch Data Processing Solutions in Microsoft Azure

 

Design Real-time Processing Solutions

Design for real-time processing by using Stream Analytics and Azure Databricks

https://docs.microsoft.com/en-us/azure/azure-databricks/databricks-stream-from-eventhubs

https://docs.microsoft.com/en-us/azure/architecture/reference-architectures/data/stream-processing-databricks

Design and provision compute resources

https://docs.microsoft.com/en-us/azure/batch/batch-pool-vm-sizes

 

Design for Data Security and Compliance (25-30%)

 

Design Security for Data Policies and Standards

Design for data encryption for data at rest and in transit

https://docs.microsoft.com/en-us/azure/security/fundamentals/encryption-overview#encryption-of-data-at-rest

https://docs.microsoft.com/en-us/azure/security/fundamentals/encryption-overview#encryption-of-data-in-transit

Design for data auditing and data masking

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

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

Design for data privacy and data classification

https://docs.microsoft.com/en-us/azure/security/fundamentals/protection-customer-data

https://docs.microsoft.com/en-us/azure/information-protection/deploy-aip-scanner

Design a data retention policy

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-long-term-backup-retention-configure

Plan an archiving strategy

https://azure.microsoft.com/en-in/solutions/architecture/backup-archive-on-premises/

https://azure.microsoft.com/es-es/blog/announcing-the-public-preview-of-azure-archive-blob-storage-and-blob-level-tiering/

https://docs.microsoft.com/en-us/azure/storage/blobs/storage-blob-storage-tiers#archive-access-tier

Plan to purge data based on business requirements

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

This brings us to the end of DP-201 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

Leave a Reply

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