DP-200 Exam Preparation: Implementing an Azure Data Solution

AVG Duration15h


This Learning Path is designed to help you and your team prepare for Microsoft's DP-200 Implementing 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 deploy and manage 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-200 exam tests your knowledge of three subject areas: implementing data storage solutions, managing and developing data processing, and monitoring and optimizing data solutions. This exam is all about implementation and configuration, so you need to know how to configure data services in the Azure portal. It includes tasks that you have to perform in a live lab. To give you some practice, we have included a number of hands-on lab exercises in this learning path.

Learning Objectives

  • Implement Azure data storage solutions
  • Manage and develop Azure data processing
  • Monitor and optimize Azure data solutions

Intended Audience

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


  • Basic experience using Microsoft Azure


Your certificate for this learning path

Training Content

Course - Intermediate - 6m
DP-200 Exam Prep - Introduction
This introduction gives an overview of the requirements for the Microsoft DP-200 Exam and how they will be covered.
Course - Beginner - 51m
Overview of Azure Services
This course gives an overview of the services available on Azure and shows how to create virtual machines and web apps using the Azure CLI and Azure Portal.
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.
Hands-on Lab - Beginner - 45m
Getting Started with Azure SQL Database
Explore the main features of Azure SQL and learn how to deploy and manage the service by connecting to the database and assigning user access in this lab.
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.
Hands-on Lab - Intermediate - 1h 15m
Using Azure Data Factory Pipelines to Copy Data
Learn how to build and trigger data pipelines in Azure Data Factory in this lab.
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 - 55m
Analyzing Resource Utilization on Azure
This course looks into how to capture log data and metrics from Azure services and feed this information into different locations for processing.
Hands-on Lab - Beginner - 1h 30m
Monitoring Resources with Azure Monitor
Learn to leverage Azure Monitor to diagnose application and infrastructure with logs, query logs with Azure log queries, and leverage alerts and action groups
Course - Intermediate - 4m
DP-200 Exam Prep - Additional Topics
This course explains some additional topics you should make sure you understand before taking the DP-200 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: Implementing an Azure Data Solution (DP-200)
Cert Prep: Implementing an Azure Data Solution (DP-200)
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).