DP-200 Exam Preparation: Implementing an Azure Data Solution

Overview Steps Author

Start Learning Path

DifficultyIntermediate

AVG Duration15h

Students3475

Ratings

4.8/5

Content

1418

Description

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

Prerequisites

Basic experience using Microsoft Azure

Certificate

Your certificate for this learning path

Training Content

1

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.

2

Course - Beginner - 51m

FREE

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.

3

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.

4

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.

Go to hands-on lab

5

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.

6

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.

Go to hands-on lab

7

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.

8

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.

Go to hands-on lab

9

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.

10

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.

Go to hands-on lab

11

Course - Intermediate - 28m

FREE

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.

12

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.

13

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.

14

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.

15

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.

Go to hands-on lab

16

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.

17

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.

Go to hands-on lab

18

Course - Intermediate - 50m

FREE

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.

19

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.

20

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

Go to hands-on lab

21

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.

22

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.

Go to hands-on lab

23

Exam - 2h 30m

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

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

About the Author

instructor-image

Guy Hummel

Azure and Google Cloud Content Lead

Students191375

Courses98

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