DP-201 Exam Preparation: Designing an Azure Data Solution

AVG Duration13h


This Learning Path is designed to help you and your team prepare for Microsoft's DP-201 Designing an Azure Data Solution exam. Even if you don't plan to take the exam, these courses and hands-on labs will help you learn how to design a variety of Azure data solutions.

Candidates who pass both the DP-200 and DP-201 exams will earn the Microsoft Certified: Azure Data Engineer Associate certification.

The DP-201 exam tests your knowledge of three subject areas: designing data storage solutions, designing data processing solutions, and designing for data security and compliance. 

Learning Objectives

  • Design Azure data storage solutions
  • Design data processing solutions
  • Design for data security and compliance

Intended Audience

  • People who want to become Azure data engineers
  • People preparing for Microsoft’s DP-201 exam


  • Basic experience using Microsoft Azure


Your certificate for this learning path

Training Content

Course - Intermediate - 3m
DP-201 Exam Prep - Introduction
This course introduces the DP-201 Exam Preparation: Designing an Azure Data Solution learning path.
Course - Intermediate - 45m
Designing an Azure Data Implementation
In this Course, you will learn how to design a data implementation using the appropriate Azure services.
Course - Beginner - 50m
Introduction to Azure Storage
In this course, you will learn how to use the core Azure Storage services as building blocks for Azure applications and virtual machines.
Course - Intermediate - 31m
Managing Azure Blob Storage
The course begins with a brief review of Azure Storage Accounts and then drills down into the details of blobs storage services, highlighting the different kinds of blobs.
Hands-on Lab - Intermediate - 2h 10m
Working with Azure Storage Using PowerShell
Working with Azure Storage using PowerShell, you will explore the different storage types, manage storage account keys, and generate shared access signatures.
Course - Beginner - 1h 10m
Designing Data Flows in Azure
In this Course, you'll learn the basic principles of designing data flows using the Azure platform.
Course - Intermediate - 1h 8m
Introduction to Azure Cosmos DB
This course shows how to make use of Cosmos DB's incredible flexibility and performance tools on Microsoft Azure.
Hands-on Lab - Intermediate - 1h 30m
Developing with the Cosmos DB Core API and Change Feed
In this Lab, you will learn how to manage Cosmos DB using the Azure Portal and Azure CLI as you integrate Azure Functions with Cosmos DB change feed triggers to buy and sell fictitious stocks.
Course - Intermediate - 28m
Introduction to Azure Synapse Analytics
This course introduces Microsoft’s Azure Synapse Analytics, covering serverless SQL pools, dedicated SQL pools, Spark pools, and Synapse Pipelines.
Course - Intermediate - 18m
Optimizing Dedicated SQL Pools in Azure Synapse Analytics
This course explains how to optimize dedicated SQL pools in Azure Synapse Analytics and provides a quick overview of the security and disaster recovery features of dedicated SQL pools.
Course - Intermediate - 42m
Running Spark on Azure Databricks
In this course, we will show you how to set up a Databricks cluster and run interactive queries and Spark jobs on it.
Course - Advanced - 39m
Using Azure Data Lake Storage Gen2
In this course, you will follow hands-on examples to import data into Azure Data Lake Storage Gen2 and then securely access it and analyze it using Azure Databricks. You will also learn how to monitor and optimize your Azure Data Lake Storage Gen2.
Hands-on Lab - Beginner - 1h
Using Azure Databricks to Import and Analyze Data
Learn to implement lightning-fast analytics by building an Azure Databricks workspace and cluster to interact with Azure Data Lake Store data.
Course - Intermediate - 50m
Introduction to Azure Stream Analytics
This course includes hands-on examples of how to configure inputs, outputs, and queries in ASA jobs, including ingesting data from Event Hubs and writing results to Data Lake Store.
Hands-on Lab - Beginner - 30m
Analyzing IoT Data Using Azure Stream Analytics
Analyze Internet of Things (IoT) sensor data using Azure Stream Analytics to identify if there have been any IoT device failures in this Lab.
Course - Intermediate - 50m
Microsoft Azure Security Solutions
This course provides you with a basic understanding of all of the key security options and features available in Microsoft Azure.
Course - Intermediate - 3m
DP-201 Exam Prep - Additional Topics
This course covers Table Storage in Azure with a focus on how to choose a partition key, which is important to know if you're preparing for DP-201 exam.
Hands-on Lab - Advanced - 1h
Enabling Microsoft Defender for Azure SQL Database
Demonstrate the three capabilities of Azure Defender (AD): data discovery & classification, vulnerability assessment, and advanced threat protection to see how AD provides security as a service for your Azure SQL Databases.
Exam - 2h 30m
Cert Prep: Designing an Azure Data Solution (DP-201)
Cert Prep: Designing an Azure Data Solution (DP-201)
About the Author
Learning paths169

Guy launched his first training website in 1995 and he's been helping people learn IT technologies ever since. He has been a sysadmin, instructor, sales engineer, IT manager, and entrepreneur. In his most recent venture, he founded and led a cloud-based training infrastructure company that provided virtual labs for some of the largest software vendors in the world. Guy’s passion is making complex technology easy to understand. His activities outside of work have included riding an elephant and skydiving (although not at the same time).