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
  • 61 Lessons
  • 8 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 6 Lessons Course Introduction 13:16

    An Important Note About A Cloud Guru and Linux Academy Courses

    1:19

    Course Introduction

    2:30

    About the Training Architect

    1:05

    About the Exam

    3:23

    Important Timeline Information about the Data Engineering Associate Certification

    3:51

    Microsoft Learn

    1:08
  • 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 12 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
  • 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 4 Lessons Course Conclusion 1:40:31

    Exam Essentials and References

    5:55

    What's Next

    3:20

    DP-201 Designing an Azure Data Solution

    1:30:00 Quiz

    Microsoft Learn Conclusion

    1:16

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.

Get Started
Who’s going to be learning?
Sign In
Welcome Back!

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