Skip to main content

Microsoft Azure Exam DP-201 – Designing an Azure Data Solution

Course

Intro Video

Photo of Brian  Roehm

Brian Roehm

Azure Training Architect I in Content

Length

15:32:28

Difficulty

Intermediate

Videos

50

Hands-on Labs

9

Quizzes/Exams

1

Course Details

This course is designed to help you develop the skills you need to pass the Microsoft Azure DP-201 certification exam. This exam measures your ability to do the following:

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

We will dive into each of these topics to prepare you for the exam and get comfortable with Azure big data and analytics.

Syllabus

Introduction

Course Introduction

Course Introduction

00:02:30

Lesson Description:

In this video, we will discuss this course and Microsoft's DP-201 Certification Exam.

About the Training Architect

00:01:05

Lesson Description:

Meet your instructor! In this video, I'll introduce myself and give you a little background on my experience.

Using the DP-201 Essentials Guide

00:01:18

Lesson Description:

In this video, we will introduce the DP-201 Essentials Guide, how to navigate, and how to leverage it to help you with your exam preparation.

About the Exam

00:03:23

Lesson Description:

Gain practical tips on what to expect on exam day, details about the exam itself, and how to prepare for the exam both today and on exam day.

Design Azure Data Storage Solutions

Recommend an Azure Data Solution Based on Requirements

An Introduction to Azure Storage

00:09:49

Lesson Description:

In this video, we introduce Azure Storage solutions with a focus on reviewing Azure applications through the lens of design.

Big Data Storage Technology Summary

00:07:23

Lesson Description:

In this video, we take a look at some of the major systems on the DP-201. We review the major components of each system and focus on the comparisons with an emphasis on design.

Choosing the Right Data Store

00:16:02

Lesson Description:

In this video, we review data stores and look at them through the lens of design. This video provides a background to better understand Azure database services we discuss later on in the course.

An Introduction to Big Data Architecture

00:09:29

Lesson Description:

In this video, we review a Microsoft big data architecture diagram and put together the discussions from the videos in this section. We also look at a real-world example of how big data architecture is designed.

Design Non-Relational Cloud Data Stores

Designing a Data Partition in Azure

00:10:42

Lesson Description:

In this video, we examine how to improve performance in Cosmos DB for our queries and manage our data more efficiently through the use of data partitions. We explore both logical and physical partitions as well as how to design a good partition key.

Designing for Global Distribution in Azure

00:06:45

Lesson Description:

Cosmos DB describes global distribution as a flagship feature. In this video, we explore why that is, and how we design our architecture to utilize this feature.

Designing for Consistency in Cosmos DB

00:11:22

Lesson Description:

In this video, we examine the different levels of consistency in Cosmos DB and look at scenarios to help determine the best choice.

Choosing the Appropriate Cosmos DB API

00:07:07

Lesson Description:

This video is a review of the multi-model capabilities of Cosmos DB with an emphasis on key features to differentiate the APIs and match them to their appropriate database model.

Designing for Disaster Recovery and High Availability

00:06:15

Lesson Description:

In this video, we explore how to design for disaster recovery and high availability using Cosmos DB.

Refresh on Data Lake Gen 2

00:07:03

Lesson Description:

In this video, we review the important concepts of Data Lake Storage Gen 2 that we need to properly design big data architecture.

Designing a Solution That Utilizes Cosmos DB, Data Lake Gen 2, or Blob Storage

00:08:30

Lesson Description:

In this video, we review three scenarios to determine the best storage solution for the problem. This gives a taste of the types of scenarios we might see on the exam as well as assists us in thinking design first.

Hands-on Labs are real live environments that put you in a real scenario to practice what you have learned without any other extra charge or account to manage.

Setting Partition Keys in Azure Cosmos DB

00:45:00

Design Relational Cloud Data Stores

Partitioning Tables

00:08:24

Lesson Description:

In this lesson, we review data partitioning in SQL Data Warehouse and look at what is required to create good data partition design.

Designing for SQL DB and SQL DW

00:04:45

Lesson Description:

In this lesson, we review comparisons of SQL DB and SQL DW through the lens of several scenarios.

Designing Data Distribution in Azure

00:05:33

Lesson Description:

This video is a review of distributed tables, how they work, and how to choose the appropriate distribution method when working with SQL Data Warehouse.

Designing for Ingestion with PolyBase

00:11:03

Lesson Description:

In this video, we learn what PolyBase is and how it can be used to enable ELT in SQL Data Warehouse. We also discuss the T-SQL statement Create Table as Select, with emphasis on the movement of data from Azure Blob and Data Lake to SQL Data Warehouse.

Designing for Scale in SQL DB

00:13:21

Lesson Description:

In this lesson, we examine how to scale up, scale out, and use PowerShell to employ dynamic scalability with our SQL database.

Designing for Scale in SQL DW

00:08:33

Lesson Description:

In this video, we examine the options for scaling in SQL DW, including cost-saving measures.

Designing for Disaster Recovery and High Availability

00:12:55

Lesson Description:

When looking at SQL DB and SQL DW, it is important to design for disaster recovery and high availability. In this lesson, we discuss the options available for both services and take a look at the Azure Portal to see how to enable them.

SQL Database Automated Backup Strategies

00:07:42

Lesson Description:

In this video, we explore how SQL database automated backup strategies work through a demo of their functionality in the Azure Portal. We also review long-term retention policies and how they function as part of an overall business continuity and disaster recovery strategy.

Design a Disaster Recovery Strategy

00:04:17

Lesson Description:

In designing a disaster recovery solution, it's important to understand the business perspective and key metrics. In this video, we explore how to design a disaster recovery strategy and learn about RPO and RTO.

Exam Essentials and References

00:05:54

Lesson Description:

This section reviews key concepts from this section and provides references.

Hands-on Labs are real live environments that put you in a real scenario to practice what you have learned without any other extra charge or account to manage.

Design for DR and HA in Azure SQL Database

00:45:00

Hands-on Labs are real live environments that put you in a real scenario to practice what you have learned without any other extra charge or account to manage.

Managing an Azure SQL Database

00:45:00

Design Data Processing Solutions

Design Batch Processing Solutions

Designing for Data Ingestion

00:07:38

Lesson Description:

In this video, we explore how we design for data ingestion, the key options available for batch ingestion, and what we need to know for the DP-201.

Designing for Processing

00:09:20

Lesson Description:

In this lesson, we explore ETL versus ELT from a design perspective. We provide a glimpse of Data Factory and discuss the key considerations when deciding the best approach to design.

Processing with Databricks

00:11:34

Lesson Description:

In this video, we introduce Databricks, walk through key terminology, and show the basics of the platform in the Portal. This video establishes the baseline needed to explain batch and streaming integration with Databricks.

Designing Batch Processing Using Data Factory

00:13:18

Lesson Description:

In this video lesson, we explore Data Factory. We examine pipelines, activities, data sets, and linked services. Then we explore a live Data Factory instance and learn how all of these services work together.

Designing Real-Time Processing Solutions

Stream Versus Batch Processing

00:06:06

Lesson Description:

In this video, we take a look into the differences between batch and streaming with a focus on design. We also explore the key questions we should ask before building data architecture.

Stream Processing in Azure

00:07:44

Lesson Description:

In this video, we continue the introduction to Azure streaming and begin to look at stream processing in the larger picture of data architecture. This video completes the design theory and sets the stage for later discussions on specific streaming solutions.

Designing for Stream Analytics

00:05:51

Lesson Description:

In this video, we explore how to utilize Stream Analytics to create stream processing jobs. We examine input, output, and query using the Azure Portal.

Designing for Streaming in Databricks

00:04:46

Lesson Description:

In this video, we explore how Databricks handles streams of data, both with a conceptual explanation as well as a sample in Azure Databricks.

Optimizing Stream Analytics

00:05:38

Lesson Description:

In this lesson, we review the key concepts to optimize Stream Analytics jobs. We discuss the concepts of streaming units and parallelization concepts.

Optimizing Streaming in Databricks

00:10:55

Lesson Description:

In this video, we step through a walkthrough of the top steps needed to optimize streaming in Databricks. We review the concepts as well as see them in action in the Portal.

Exam Essentials and References

00:05:00

Lesson Description:

In this video, we review the key concepts for this section and references.

Design for Data Security and Compliance

Design Security for Source Data Access

Planning for Secure Endpoints

00:06:01

Lesson Description:

What is a service endpoint and how does it differ from a private endpoint? In this video, we explore the differences and walk through an example of how to configure both private and service endpoints in the Azure Portal.

Authenticate with Azure Active Directory

00:07:57

Lesson Description:

In this video, we cover an overview of Azure Active Directory (AD). This includes the basics of AD and taking a live look at how to manage access, create an admin, and add SQL database users.

Authenticate with Access Keys

00:05:51

Lesson Description:

In this video, we explore how to leverage Azure Key Vault to authenticate users with access keys.

Authenticate with Shared Access Signatures

00:07:08

Lesson Description:

In this video, we explore what a shared access signature (SAS) is and how to authenticate with it using the Azure Portal.

Hands-on Labs are real live environments that put you in a real scenario to practice what you have learned without any other extra charge or account to manage.

01:30:00

Hands-on Labs are real live environments that put you in a real scenario to practice what you have learned without any other extra charge or account to manage.

02:00:00

Design Security for Data Policies and Standards

Defense in Depth

00:07:14

Lesson Description:

In this video, we think critically about the Defense in Depth model, how it differs from Zero Trust, and how we can employ Defense in Depth as we build data architecture.

RBAC

00:04:25

Lesson Description:

This lesson covers an overview of role-based access control (RBAC), how it works, and how to apply it to manage user access.

Data Encryption in Transit and at Rest

00:09:54

Lesson Description:

This lesson provides a high-level overview of how data is encrypted at rest and in motion for Azure SQL Server, SQL Database, SQL Data Warehouse, Cosmos DB, and Data Lake. In addition, we cover some data encryption theory and walk through several features of the Azure Portal.

SQL Database Auditing

00:06:12

Lesson Description:

In this video, we explore one of the DP-201 requirements, SQL database auditing. We examine what is turned on by default, why we would use SQL database auditing, and how to configure the service.

Data Masking Review

00:03:33

Lesson Description:

In this video, we review the basic concepts of dynamic data masking (DDM) as a refresher from the DP-200.

Plan an Archiving Strategy

00:05:35

Lesson Description:

In this lesson, we examine the tiers of Azure Blob Storage, their functionality, and how to determine pricing. We also take a live look in the Azure Portal to understand how easy it is to change blob storage tiers.

Design a Data Retention Policy

00:04:33

Lesson Description:

Designing a data retention policy is one of the requirements for the DP-201. In this video, we explore the concepts of tape versus archive tier, cool versus archive, and how we automate things using lifecycle management.

Azure Data Security Best Practices

00:05:27

Lesson Description:

In this video, we review the concepts from this section and focus on how to design data solutions that implement best practices.

Hands-on Labs are real live environments that put you in a real scenario to practice what you have learned without any other extra charge or account to manage.

Configure Data Masking in Azure SQL Database

00:45:00

Hands-on Labs are real live environments that put you in a real scenario to practice what you have learned without any other extra charge or account to manage.

Design a Data Retention Policy in Azure Blob

00:45:00

Course Conclusion

Course Conclusion

Exam Essentials and References

00:05:54

Lesson Description:

In this video, we will cover the key concepts for this section and references for review.

What's Next

00:03:19

Lesson Description:

Now that we have finished the course content, this video will provide the next steps in your journey to pass the DP-201 exam.

Take this course and learn a new skill today.

Transform your learning with our all access plan.

Start 7-Day Free Trial