Microsoft Azure Exam DP-200 – Implementing an Azure Data Solution
June 21st, 2019
Azure Training Architect I in Content
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.
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
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
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
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
Designing a Data Schema
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
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
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
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
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
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
This video provides an introduction to Azure Table Storage, how it works, and how it differs from the Cosmos DB Table API.
Implement Relational Data Stores
Data Warehouse Introduction
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
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
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
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
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
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
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
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
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
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.
Manage and Develop Data Processing
Develop Batch Processing Solutions
Batch Processing Overview
In this lesson, we will learn what batch processing is and how it fits into the larger cloud architecture framework.
Apache Spark Overview
In this video, we will explore the basics of Apache Spark, what it is, and how it works.
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.
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
This lesson provides an overview of stream processing and how Azure Stream Analytics works.
Azure Stream Windowing Functions
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
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
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
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
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
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
This lesson provides an overview of the native toolsets available for reviewing performance in SQL Database and SQL Data Warehouse.
Implement Cosmos DB Monitoring
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
A look at typical monitoring scenarios and the mechanics needed to configure them in Azure Stream Analytics.
Monitoring Data Factory
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
A high level look at the monitoring options that are available in Azure Databricks.
Manage and Troubleshoot Azure Data Solutions
Optimizing SQL Data Warehouse Performance
In this video, we will discuss optimization strategies for SQL Data Warehouse.
Optimizing Data Lake Performance
In this video, we will discuss how to manage input/output and files to optimize Azure Data Lake performance.
Optimizing Azure Stream Analytics
In this video, we will discuss optimization strategies for Azure Stream Analytics jobs.
Optimizing SQL Database Performance
In this video, we will go over tips for optimizing SQL Database performance.
Managing the Data Lifecycle
In this video, we will review how to manage the data lifecycle of an Azure blob.
DP-200: Implementing an Azure Data Solution
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
A quick review of the essential concepts you need to understand to master the DP-200.