DP-200 Exam Preparation: Implementing an Azure Data Solution

AVG Duration15h
Course Created with Sketch. 13 Exams Created with Sketch. 1 Labs Created with Sketch. 7


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

Learning Path Steps


This introduction gives an overview of the requirements for the Microsoft DP-200 Exam and how they will be covered.


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.


In this course, you will learn how to design a data implementation using the appropriate Azure services.


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.


Working with Azure Storage using PowerShell, you will explore the different storage types, manage storage account keys, and generate shared access signatures.


In this course, you'll learn the basic principles of designing data flows using the Azure platform.


Learn how to build and trigger data pipelines in Azure Data Factory in this lab.


This course shows how to make use of Cosmos DB's incredible flexibility and performance tools on Microsoft Azure.


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.


This course introduces Microsoft’s Azure Synapse Analytics, covering serverless SQL pools, dedicated SQL pools, Spark pools, and Synapse Pipelines.


In this course, we will show you how to set up a Databricks cluster and run interactive queries and Spark jobs on it.


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.


Learn to implement lightning-fast analytics by building an Azure Databricks workspace and cluster to interact with Azure Data Lake Store data.


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.


Analyze Internet of Things (IoT) sensor data using Azure Stream Analytics to identify if there have been any IoT device failures in this Lab.


This course provides you with a basic understanding of all of the key security options and features available in Microsoft Azure.


This course looks into how to capture log data and metrics from Azure services and feed this information into different locations for processing.


Learn to leverage Azure Monitor to diagnose application and infrastructure with logs, query logs with Azure log queries, and leverage alerts and action groups


This course explains some additional topics you should make sure you understand before taking the DP-200 Exam.


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.


Cert Prep: Implementing an Azure Data Solution (DP-200)

About the Author
Learning paths76

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).