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

By Brian Roehm

Prepare for Microsoft's Designing an Azure Data Solution (DP-201) certification exam.

16 hours
  • 60 Lessons
  • 9 Hands-On Labs
  • 1 Practice Exam

About the course

This course is designed to help you develop the skills you need to pass the Microsoft’s Designing an Azure Data Solution (DP-201) certification exam. This exam measures your ability to:

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

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

  • Chapter 1 5 Lessons Course Introduction 9:36

    An Important Note About A Cloud Guru and Linux Academy Courses

    1:19

    Course Introduction

    2:30

    About the Training Architect

    1:05

    Using the DP-201 Essentials Guide

    1:19

    About the Exam

    3:23
  • Chapter 2 4 Lessons Recommend an Azure Data Solution Based on Requirements 42:45

    An Introduction to Azure Storage

    9:50

    Big Data Storage Technology Summary

    7:24

    Choosing the Right Data Store

    16:02

    An Introduction to Big Data Architecture

    9:29
  • Chapter 3 8 Lessons Design Non-Relational Cloud Data Stores 57:47

    Designing a Data Partition in Azure

    10:42

    Designing for Global Distribution in Azure

    6:45

    Designing for Consistency in Cosmos DB

    11:23

    Choosing the Appropriate Cosmos DB API

    7:07

    Designing for Disaster Recovery and High Availability

    6:16

    Refresh on Data Lake Gen 2

    7:04

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

    8:30

    Setting Partition Keys in Azure Cosmos DB

    0:00 Hands-On Lab
  • Chapter 4 13 Lessons Design Relational Cloud Data Stores 1:22:33

    Partitioning Tables

    8:24

    Designing for SQL DB and SQL DW

    4:46

    Designing Data Distribution in Azure

    5:34

    Designing for Ingestion with PolyBase

    11:03

    Designing for Scale in SQL DB

    13:21

    Designing for Scale in SQL DW

    8:33

    Designing for Disaster Recovery and High Availability

    12:56

    SQL Database Automated Backup Strategies

    7:43

    Design a Disaster Recovery Strategy

    4:18

    Exam Essentials and References

    5:55

    Design for DR and HA in Azure SQL Database

    0:00 Hands-On Lab

    Managing an Azure SQL Database

    0:00 Hands-On Lab

    Create a Data Partition in Azure SQL Data Warehouse

    0:00 Hands-On Lab
  • Chapter 5 4 Lessons Design Batch Processing Solutions 41:53

    Designing for Data Ingestion

    7:39

    Designing for Processing

    9:20

    Processing with Databricks

    11:35

    Designing Batch Processing Using Data Factory

    13:19
  • Chapter 6 7 Lessons Designing Real-Time Processing Solutions 46:03

    Stream Versus Batch Processing

    6:07

    Stream Processing in Azure

    7:45

    Designing for Stream Analytics

    5:51

    Designing for Streaming in Databricks

    4:46

    Optimizing Stream Analytics

    5:39

    Optimizing Streaming in Databricks

    10:55

    Exam Essentials and References

    5:00
  • Chapter 7 6 Lessons Design Security for Source Data Access 27:00

    Planning for Secure Endpoints

    6:02

    Authenticate with Azure Active Directory

    7:57

    Authenticate with Access Keys

    5:52

    Authenticate with Shared Access Signatures

    7:09

    Configuration and Security of Azure Storage Accounts

    0:00 Hands-On Lab

    Using Azure Key Vault

    0:00 Hands-On Lab
  • Chapter 8 11 Lessons Design Security for Data Policies and Standards 46:58

    Defense in Depth

    7:15

    RBAC

    4:26

    Data Encryption in Transit and at Rest

    9:54

    SQL Database Auditing

    6:12

    Data Masking Review

    3:34

    Plan an Archiving Strategy

    5:36

    Design a Data Retention Policy

    4:34

    Azure Data Security Best Practices

    5:27

    Configure Data Masking in Azure SQL Database

    0:00 Hands-On Lab

    Design a Data Retention Policy in Azure Blob

    0:00 Hands-On Lab

    Azure SQL Database Auditing

    0:00 Hands-On Lab
  • Chapter 9 3 Lessons Course Conclusion 1:39:15

    Exam Essentials and References

    5:55

    What's Next

    3:20

    DP-201 Designing an Azure Data Solution

    1:30:00 Quiz

What you will need

  • Before taking the DP-201 course please complete the DP-200 course and have familiarity with the concepts in the AZ-900 course. Basic database knowledge is also helpful but not required.

What are Hands-on Labs

What's the difference between theoretical knowledge and real skills? Practical real-world experience. That's where Hands-on Labs come in! Hands-on Labs are guided, interactive experiences that help you learn and practice real-world scenarios in real cloud environments. Hands-on Labs are seamlessly integrated in courses, so you can learn by doing.

Practice alongside courses in Cloud Playground

What is Cloud Playground? Cloud Playground lets you build skills in real-world AWS, Google Cloud, and Azure environments. Spin up risk-free Sandboxes, Servers and Terminals and follow along with courses, test a new idea or prepare for exams.

Get Started
Who’s going to be learning?

How many seats do you need?

  • $499 USD per seat per year
  • Billed Annually
  • Renews in 12 months

Ready to accelerate learning?

For over 25 licenses, a member of our sales team will walk you through a custom tailored solution for your business.


$2,495.00

Checkout
Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!