DP-203: Data Engineering in Microsoft Azure, Part 7 of 7: Optimize and Design Azure Data Solutions
with expert Eshant Garg
Course description
The DP-203 Exam is measured in Four domains: Design and implement data storage (40-45%), Design and develop data processing (25-30%), Design and implement data security (10-15%), and Monitor and optimize data storage and data processing (10-15%).
This course covers how to Design and Optimize Azure Data Solutions.
Prerequisites
AZ-900 Azure Fundamentals is very helpful but not required. A Candidate for the exam must have strong knowledge of data processing languages such as SQL, Python, or Scala, and they need to understand parallel processing and data architecture patterns.
Meet the expert
Eshant Garg has 16 years of extensive professional experience with expertise in Database and Business Intelligence Solutions, Advanced Analytics, Design and Solution Architect, Reporting, and Cloud Computing Technologies (Azure & AWS).
As a developer and architect, he has worked closely with customers, users, and colleagues to support business solutions across a variety of industries including healthcare, insurance, finance, and government ranging from small companies to fortune 500 companies.
Course outline
Module 18
Optimize Azure Data Solutions (25:20)
- Introduction (00:08)
- Learning Objectives (02:16)
- Troubleshoot Data Partitioning Bottlenecks (06:53)
- Optimization (05:35)
- Optimizing Stream Analytics (10:19)
- Summary (00:08)
Optimizing Synapse Analytics Service (23:57)
- Introduction (00:08)
- Optimizing Synapse Analytics Service (09:50)
- Managing The Data Lifecycle (13:50)
- Summary (00:08)
Types of Data (30:04)
- Introduction (00:08)
- Four Types Of Data (11:35)
- Data Store Types (18:13)
- Summary (00:08)
Module 19
Select Azure Store for Application (30:23)
- Introduction (00:08)
- Select Azure Store For Application (04:04)
- Azure Data Platform Architecture (05:38)
- Rto And Rpo (04:07)
- Designing A Solution That Utilizes Cosmos Db Data (10:11)
- Designing For Sql DB vs. Dw (06:04)
- Summary (00:08)
Designing Batch Processing Solutions (29:56)
- Introduction (00:08)
- Designing Batch Processing Soluttions (16:54)
- Data Ingestion Methods (12:46)
- Summary (00:08)
Real Time Processing (20:24)
- Introduction (00:08)
- Real Time Processing (11:26)
- Design And Provision Compute Resources (08:42)
- Summary (00:08)
Lambda Architecture (16:49)
- Introduction (00:08)
- Lambda Architecture (09:36)
- Planning For Secure Endpoints (06:56)
- Summary (00:08)