DP-201 Exam Study Guide (Designing An Azure Data Solution)
You can access DP-201 Exam Microsoft official page here
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 the DP-201 exam. Please share the post within your circles so it helps them to prepare for the exam.
DP-203 will replace both DP-200 and DP-201 in the coming months.
Skills Measured
- Design Azure Data Storage Solutions (40-45%)
- Design Data Processing Solutions (25-30%)
- Design for Data Security and Compliance (25-30%)
DP-201 Exam Free Study Guide
For each test objective, I’ve compiled a thorough collection of articles from Microsoft documentation. Please feel free to forward this page to your friends and coworkers in order to assist them in preparing for the test .
Design Azure Data Storage Solutions (40-45%)
Recommend an Azure Data Solution Based on Requirements
- Choose the correct data storage solution to meet the technical and business requirements
- Understand data store models
- Choosing a big data storage technology in Azure
- Choose the partition distribution type
- Data partitioning strategies
- Horizontal, vertical, & functional data partitioning
Design Non-relational Cloud Data Stores
- Design data distribution and partitions
- Partitioning & horizontal scaling in Azure Cosmos DB
- Global data distribution with Azure Cosmos DB
- Design for scale, including multi-region, latency, and throughput
- Introduction to provisioned throughput in Azure Cosmos DB
- Partitioning & horizontal scaling in Azure Cosmos DB
- Check the Module ‘Tuning for throughput and performance’
- Design a solution that uses Cosmos DB, Data Lake Storage Gen2, or Blob storage
- Going social with Azure Cosmos DB
- Host a static website in Azure Storage
- Select the appropriate Cosmos DB API
- Choose the appropriate API for Azure Cosmos DB
- Design a disaster recovery strategy
- Choose the appropriate API for Azure Cosmos DB
- Design for high availability
- How does Azure Cosmos DB provide high availability?
Design Relational Cloud Data Stores
- Design data distribution and partitions
- Guidance for designing distributed tables in Synapse SQL pool
- Design for scale (including latency, and throughput)
- Azure Synapse Analytics instance scaling
- Scale compute for Synapse SQL pool with the Azure portal
- Design a solution that uses Azure Synapse Analytics
- Load data from Azure Data Lake Storage for Synapse SQL
- Design a disaster recovery strategy
- Backup and restore in Azure Synapse Dedicated SQL pool
- Disaster Recovery in Azure Synapse Analytics
- Design for high availability
- High availability for Azure Synapse Analytics
- 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 ADF & Azure Databricks
- Identify the optimal data ingestion method for a batch processing solution
- Technology choices for batch processing
- Azure Data Explorer data ingestion overview
- 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
- Stream data into Azure Databricks using Event Hubs
- Stream processing pipeline with Azure Databricks
- Design and provision compute resources
- Choose a VM size for compute nodes in an Azure Batch pool
Design for Data Security and Compliance (25-30%)
Design Security for Source Data Access
- Plan for secure endpoints
-
Use private endpoints for Azure Storage
Choose the appropriate authentication mechanism, such as access keys, shared access signatures (SAS), and Azure Active Directory (Azure AD)
Azure Blob Storage
Authorize access to blobs and queues using Azure AD
Grant limited access to Azure Storage resources using SAS
Manage storage account access keys
Azure SQL Database
SQL Database, SQL Managed Instance, & Azure Synapse Analytics
Design Security for Data Policies and Standards
- Design for data encryption for data at rest and in transit
- Encryption of data at rest
- Encryption of data in transit
- Design for data auditing and data masking
- Auditing: Azure SQL Database & Azure Synapse Analytics
- Dynamic data masking
- Design for data privacy and data classification
- Azure customer data protection
- Azure Information Protection unified labeling scanner
- Design a data retention policy
- Manage Azure SQL Database LTR
- Plan an archiving strategy
- Solution architecture: Archive on-premises data to the cloud
- Azure Archive Blob Storage & Blob-Level Tiering
- Archive access tier
- Plan to purge data based on business requirements
- Manage the Azure Blob storage lifecycle
This brings us to the end of the DP-201 Study Guide
Follow Me to Receive Updates on DP-201 Exam
