Microsoft Azure Exam DP-200 – Implementing an Azure Data Solution

Course

June 21st, 2019

Intro Video

Photo of Brian  Roehm

Brian Roehm

Azure Training Architect I in Content

Length

08:40:16

Difficulty

Intermediate

Course Details

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

Implement data storage solutionsManage and develop data processingMonitor data solutionsManage and troubleshoot Azure data solutions

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

Interactive Diagram

Syllabus

Introduction

Course Introduction

Course Introduction

00:02:13

Lesson Description:

This course will help to establish a foundation for your journey to become an Azure Data Engineer. Through video lessons, labs, practice exams, and other material you will gain the experience needed to pass the DP-200 exam (the first of 2 to acheive the Azure Data Engineer Associate certification). Although this class is designed to cater to students of all skill levels, as a helpful start, students should have a basic understanding of Azure concepts, technologies and tools. Helpful Support Make sure that you reach out to me directly with any questions and concerns. I want to partner with you through this journey to passing your DP-200. Make sure to join the Linux Academy Community Slack HERE and check out the #azure channel. The Linux Academy Community provides you with access to like-minded students and staff who can help you learn!

About the Training Architect

00:01:08

Lesson Description:

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

Using the DP-200 Essentials Guide

00:01:57

Lesson Description:

An introduction to the DP-200 Essentials Guide, how to navigate, and how to leverage it to help you with your exam preparation.

About the Exam

00:03:52

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.

Implement Data Storage Solutions

Introductory Concepts

Designing a Data Schema

00:03:30

Lesson Description:

In this video, we'll go over the basics of data modeling and familiarize ourselves with the star and snowflake schemas. These modeling concepts will provide the foundation for us as we learn more Azure tools later in the course.

SQL Databases, SQL Data Warehouses, and Data Lakes

00:04:27

Lesson Description:

In this video, we will review the core concepts of Azure SQL Database, Azure SQL Data Warehouse, and Azure Data Lake Store. We will discuss the differences between these three options, which will be helpful to us when we dive into more advanced implementation concepts.

Implement Non-Relational Data Stores

Introduction to NoSQL

00:06:46

Lesson Description:

In this video, we will build a basic foundational understanding of NoSQL, focusing on the concepts covered on the DP200 exam. We will discuss the following topics: What is NoSQL? Common use cases SQL vs. NoSQL The four main NoSQL database types

Azure Data Lake Introduction

00:09:00

Lesson Description:

In this video, we will learn about the concept of a data lake. We will cover: Azure Data Lake versions Performance File management Security Cost effectiveness The movement of data through a data lake

Cosmos DB Essentials

00:15:06

Lesson Description:

This video provides an introduction to Azure Cosmos DB, including its key features, appropriate uses, and functionality. Specifically, we will discuss: Global distributionConsistency levelsAvailabilityMulti-model funcionality

Partitioning and Horizontal Scaling in Cosmos DB

00:07:18

Lesson Description:

In this video, we will discuss partitioning, scaling, and establishing throughput in Cosmos DB. We will see how containers are broken down into logical and physical partitions (including a brief discussion on replica sets) based upon a partition key. We will also view a live demo of the Azure portal to illustrate the process of creating and managing containers.

Azure Table Storage Overview

00:04:41

Lesson Description:

This video provides an introduction to Azure Table Storage, how it works, and how it differs from the Cosmos DB Table API.

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.

00:30:00

Implement Relational Data Stores

Data Warehouse Introduction

00:07:53

Lesson Description:

Understanding data warehouses is essential for passing the DP-200 exam. In this video, we will discuss the core concepts you need to know to understand the advanced applications covered in this certification course. Specifically, we will: Review the basics of a data warehouseDiscuss the differences between an on-premises data warehouse and a cloud data warehouseLearn the differences between relational and non-relational databasesIdentify data models and fact tables

SQL Data Warehouse Overview

00:06:45

Lesson Description:

This video provides an overview of Azure SQL Data Warehouse, how it fits into the larger Microsoft Azure roadmap, and the features that set it apart from other services.

Overview of SQL Database

00:09:34

Lesson Description:

This video provides an overview of Azure SQL Database. We will discuss the following topics: SQL Database functionalityPurchase modelsGeo-replicationSingle, elastic, and managed instances

SQL Database Hyperscale

00:04:40

Lesson Description:

This video provides a brief overview of Azure Hyperscale, how it functions (including a live demonstration in the Azure Portal), and possible use cases.

Elastic Pools and Elastic Jobs

00:06:22

Lesson Description:

In this video, we will learn about elastic pools and jobs, how they work, their key features, and how to create and interact with them in the Azure Portal.

Managed Instances in SQL DB

00:03:02

Lesson Description:

In this video, we will discuss SQL Database Managed Instance, what it was designed for, and how it differs from other SQL Database options.

Automated Backup Strategies

00:07:42

Lesson Description:

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

Managing Data Security

Implement Data Masking

00:06:19

Lesson Description:

In this lesson, we will learn what dynamic data masking (DDM) is and how to apply it using a variety of Azure methods.

Encrypt Data at Rest and in Motion

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 will cover some data encryption theory and walk through several features of the Azure Portal.

Exam Essentials and References

00:03:03

Lesson Description:

In this lesson, we will go over some tips for preparing for the Implement Azure Cloud Data Warehouses section of the DP-200 exam, as well as some useful Microsoft documentation.

Practice Exam

Manage and Develop Data Processing

Develop Batch Processing Solutions

Batch Processing Overview

00:06:29

Lesson Description:

In this lesson, we will learn what batch processing is and how it fits into the larger cloud architecture framework.

Apache Spark Overview

00:06:55

Lesson Description:

In this video, we will explore the basics of Apache Spark, what it is, and how it works.

Databricks Introduction

00:12:50

Lesson Description:

In this video, we will explore Apache Databricks. We will learn about the basic functionality of the service, go over key terminology, and take a tour of the Azure Portal to see it in action.

PolyBase Introduction

00:11:03

Lesson Description:

In this video, we will learn what PolyBase is and how it can be used to enable ELT in SQL Data Warehouse. We will 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.

Develop Streaming Solutions

Introduction to Azure Stream Analytics

00:12:14

Lesson Description:

This lesson provides an overview of stream processing and how Azure Stream Analytics works.

Azure Stream Windowing Functions

00:13:10

Lesson Description:

In this lesson, we will take an in-depth look at the different types of windowing functions that are available in Azure Stream Analytics and how they work.

Using Reference Data for Lookups in Stream Analytics

00:06:23

Lesson Description:

In this lesson, we will learn about reference data and how to apply it to Azure Stream Analytics.

Develop Integration Solutions

Introduction to Azure Data Factory

00:07:19

Lesson Description:

In this video, we will go over key concepts and terminology related to Azure Data Factory and take a look at the service in the Azure Portal.

Create and Schedule Triggers

00:05:34

Lesson Description:

In this video, we will discuss the role of triggers in Azure Data Factory. Specifically, we will talk about what triggers are and how they are used to automate pipeline kickoff.

Monitor Data Solutions

Monitor Data Storage

Monitoring a Storage Account in the Azure Portal

00:07:35

Lesson Description:

In this lesson, we will discuss the monitoring that is available through Azure Storage. We will review some introductory monitoring concepts and see how monitoring works in a walkthrough of the Azure portal.

Azure Storage Metrics in Azure Monitor

00:13:19

Lesson Description:

In this lesson, we will discuss Azure Monitor, why it is used, where it fits in the overall cloud landscape, and what types of monitoring and alerts are available.

Implementing Monitoring in SQL Database and SQL Data Warehouse

00:07:06

Lesson Description:

This lesson provides an overview of the native toolsets available for reviewing performance in SQL Database and SQL Data Warehouse.

Implement Cosmos DB Monitoring

00:05:08

Lesson Description:

This lesson provides an overview of the native toolsets available for reviewing performance and configuring alerts in Cosmos DB.

Monitor Data Processing

Monitoring Stream Analytics

00:06:53

Lesson Description:

A look at typical monitoring scenarios and the mechanics needed to configure them in Azure Stream Analytics.

Monitoring Data Factory

00:08:13

Lesson Description:

A live look at how monitoring is implemented in Data Factory. In this video, we will discuss both Azure Monitor and native monitoring through Data Factory.

Monitoring Azure Databricks

00:04:03

Lesson Description:

A high level look at the monitoring options that are available in Azure Databricks.

Manage and Troubleshoot Azure Data Solutions

Manage Optimization

Optimizing SQL Data Warehouse Performance

00:07:15

Lesson Description:

In this video, we will discuss optimization strategies for SQL Data Warehouse.

Optimizing Data Lake Performance

00:07:10

Lesson Description:

In this video, we will discuss how to manage input/output and files to optimize Azure Data Lake performance.

Optimizing Azure Stream Analytics

00:05:38

Lesson Description:

In this video, we will discuss optimization strategies for Azure Stream Analytics jobs.

Optimizing SQL Database Performance

00:04:29

Lesson Description:

In this video, we will go over tips for optimizing SQL Database performance.

Managing the Data Lifecycle

00:05:39

Lesson Description:

In this video, we will review how to manage the data lifecycle of an Azure blob.

Practice Exam

Course Conclusion

Course Conclusion

What's Next

00:03:25

Lesson Description:

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

Exam Essentials and References

00:03:02

Lesson Description:

A quick review of the essential concepts you need to understand to master the DP-200.