DP-300 Coverage Map
This page maps every topic in Ehab's Azure Wiki to the official DP-300 exam domains. Use it to track your progress, identify gaps, and choose the right study sequence for your background.
How to Use This Wiki
| Your Background | Recommended Approach |
|---|---|
| Oracle DBA → Azure | Start with Oracle → Azure Mapping, then follow the DP-300 modules in order. Every page includes Oracle DBA parallels. |
| DP-300 Exam Prep | Follow the 5 domains below in order. Focus on pages marked 🎯 Core Exam. Use flashcards and quizzes after each section. |
| Quick Revision | Jump to any specific topic using the links below. Each page has a summary table, flashcards, and quiz at the end. |
Suggested Study Sequences
Path 1: Oracle DBA Transitioning to Azure
| Step | Page | Why |
|---|---|---|
| 1 | Oracle → Azure Mapping | Map every Oracle concept to Azure |
| 2 | ACE Learning Plan | Certification roadmap and weekly schedule |
| 3 | Azure SQL Options | SQL DB vs MI vs VM — which is your Oracle replacement |
| 4 | vCore vs DTU | Purchasing models (no Oracle equivalent) |
| 5 | HA/DR Overview | Data Guard → Failover Groups, RAC → BC Tier |
| 6 | Performance Tuning | AWR → Query Store, ASH → DMVs |
| 7 | Security | Oracle Wallet → Key Vault, VPD → RLS |
Path 2: DP-300 Exam Focused
| Step | Domain | Pages |
|---|---|---|
| 1 | Plan & Implement | Azure SQL Options → vCore vs DTU → SQL VM Config → Azure SQL DB Config → Migration |
| 2 | Security | Authentication → Encryption → Compliance |
| 3 | Monitor & Optimize | Performance Tuning → Index Design → Advanced Monitoring |
| 4 | Automation | Overview → SQL Agent → Elastic Jobs → Deployment → Alerts |
| 5 | HA/DR | HA/DR Overview → Backup/Restore → Always On → MI HA → Log Shipping |
Path 3: Quick Revision (2-3 hours)
| Focus | Pages |
|---|---|
| Architecture | Azure SQL Options, vCore vs DTU |
| Performance | Performance Tuning (Query Store section) |
| HA/DR | HA/DR Overview, Backup/Restore |
| Security | Encryption & Network |
| Flashcards only | Every page has flashcards — use the flip cards at the bottom of each page |
Domain 1: Plan and Implement Data Platform Resources (20-25%)
| Topic | Page | Status | Tag |
|---|---|---|---|
| Azure SQL deployment options (DB, MI, VM) | Azure SQL Options | ✅ Covered | 🎯 Core Exam |
| vCore vs DTU purchasing models | vCore vs DTU | ✅ Covered | 🎯 Core Exam |
| GP, BC, Hyperscale architecture | vCore vs DTU + Azure SQL DB | ✅ Covered | 🎯 Core Exam |
| SQL VM storage best practices | SQL VM Configuration | ✅ Covered | 🎯 Core Exam |
| SQL VM settings (MAXDOP, tempdb, memory) | SQL VM Configuration | ✅ Covered | 🎯 Core Exam |
| Azure SQL DB configuration & resource governance | Azure SQL DB Config | ✅ Covered | 🎯 Core Exam |
| Compatibility level & IQP features | Azure SQL DB Config | ✅ Covered | 🎯 Core Exam |
| Serverless & Elastic Pools | Azure SQL DB Config + vCore vs DTU | ✅ Covered | 📖 Deep Dive |
| Migration strategies (DMS, BACPAC, SSMA) | Migration Strategy | ✅ Covered | 🎯 Core Exam |
| PostgreSQL & MySQL on Azure | PostgreSQL & MySQL | ✅ Covered | 📚 Reference |
| SQL IaaS Agent Extension | SQL VM Configuration | ✅ Covered | 📖 Deep Dive |
Domain 2: Implement a Secure Environment (15-20%)
| Topic | Page | Status | Tag |
|---|---|---|---|
| SQL Auth vs Entra ID vs Managed Identity | Authentication & Authorization | ✅ Covered | 🎯 Core Exam |
| Database roles & permissions | Authentication & Authorization | ✅ Covered | 🎯 Core Exam |
| Row-Level Security & Dynamic Data Masking | Authentication & Authorization | ✅ Covered | 🎯 Core Exam |
| TDE (at rest) | Encryption & Network | ✅ Covered | 🎯 Core Exam |
| Always Encrypted (in use) | Encryption & Network | ✅ Covered | 🎯 Core Exam |
| TLS (in transit) | Encryption & Network | ✅ Covered | 📖 Deep Dive |
| Azure Key Vault integration | Encryption & Network + Key Vault | ✅ Covered | 🎯 Core Exam |
| Firewall rules & Private Endpoints | Networking | ✅ Covered | 🎯 Core Exam |
| Service Endpoints vs Private Endpoints | Networking | ✅ Covered | 🎯 Core Exam |
| SQL Auditing & Advanced Threat Protection | Compliance & Security | ✅ Covered | 🎯 Core Exam |
| Vulnerability Assessment | Compliance & Security | ✅ Covered | 📖 Deep Dive |
| Database Ledger | Compliance & Security | ✅ Covered | 📚 Reference |
Domain 3: Monitor, Tune, and Optimize Resources (20-25%)
| Topic | Page | Status | Tag |
|---|---|---|---|
| Azure Monitor metrics & alerts | Azure Monitor | ✅ Covered | 🎯 Core Exam |
| Query Store | Performance Tuning | ✅ Covered | 🎯 Core Exam |
| DMVs (wait stats, sessions, requests) | Performance Tuning | ✅ Covered | 🎯 Core Exam |
| Automatic Tuning | Azure SQL DB Config | ✅ Covered | 🎯 Core Exam |
| Intelligent Query Processing | Azure SQL DB Config | ✅ Covered | 🎯 Core Exam |
| Index design (clustered, nonclustered, columnstore) | Index Design & Tuning | ✅ Covered | 🎯 Core Exam |
| Missing index DMVs | Index Design & Tuning | ✅ Covered | 🎯 Core Exam |
| Extended Events | Advanced Monitoring | ✅ Covered | 📖 Deep Dive |
| Resource Governor | Advanced Monitoring | ✅ Covered | 📖 Deep Dive |
| Execution plan analysis | Performance Tuning | ✅ Covered | 🎯 Core Exam |
| KQL for Log Analytics | Azure Monitor | ✅ Covered | 📖 Deep Dive |
Domain 4: Configure and Manage Automation of Tasks (10-15%)
| Topic | Page | Status | Tag |
|---|---|---|---|
| SQL Server Agent jobs | SQL Agent Jobs | ✅ Covered | 🎯 Core Exam |
| Elastic Jobs | Elastic Jobs & Azure Automation | ✅ Covered | 🎯 Core Exam |
| Azure Automation Runbooks | Elastic Jobs & Azure Automation | ✅ Covered | 🎯 Core Exam |
| Logic Apps & Azure Functions | Elastic Jobs & Azure Automation | ✅ Covered | 📖 Deep Dive |
| Database deployment (ARM, Bicep, DACPAC) | Deployment Automation | ✅ Covered | 🎯 Core Exam |
| Alerts & Action Groups | Alerts & Troubleshooting | ✅ Covered | 🎯 Core Exam |
| Job troubleshooting | Alerts & Troubleshooting | ✅ Covered | 📖 Deep Dive |
| Automation tool selection | Decision Matrix | ✅ Covered | 📚 Reference |
Domain 5: Plan and Configure a High Availability and Disaster Recovery Environment (20-25%)
| Topic | Page | Status | Tag |
|---|---|---|---|
| Automated backups (full, diff, log) | Backup, Restore, PITR & LTR | ✅ Covered | 🎯 Core Exam |
| Point-in-Time Restore (PITR) | Backup, Restore, PITR & LTR | ✅ Covered | 🎯 Core Exam |
| Long-Term Retention (LTR) | Backup, Restore, PITR & LTR | ✅ Covered | 🎯 Core Exam |
| Backup storage redundancy (LRS/ZRS/GRS) | Backup, Restore, PITR & LTR | ✅ Covered | 🎯 Core Exam |
| Geo-restore | Backup, Restore, PITR & LTR | ✅ Covered | 🎯 Core Exam |
| Active Geo-Replication | HA/DR Overview | ✅ Covered | 🎯 Core Exam |
| Auto-Failover Groups | HA/DR Overview | ✅ Covered | 🎯 Core Exam |
| Geo-Rep vs Failover Groups comparison | HA/DR Overview | ✅ Covered | 🎯 Core Exam |
| RPO and RTO concepts | Backup, Restore, PITR & LTR | ✅ Covered | 🎯 Core Exam |
| Always On AG on Azure VMs | SQL VM Always On | ✅ Covered | 🎯 Core Exam |
| Azure ILB for AG Listener | SQL VM Always On | ✅ Covered | 🎯 Core Exam |
| WSFC & Quorum (Cloud Witness) | SQL VM Always On + Log Shipping & FCI | ✅ Covered | 🎯 Core Exam |
| MI HA architecture (GP vs BC) | MI HA Architecture | ✅ Covered | 🎯 Core Exam |
| MI Failover Groups | MI HA Architecture | ✅ Covered | 🎯 Core Exam |
| Log Shipping | Log Shipping & FCI | ✅ Covered | 📖 Deep Dive |
| Failover Cluster Instance (FCI) | Log Shipping & FCI | ✅ Covered | 📖 Deep Dive |
Coverage Summary
| Domain | Weight | Pages | Core Topics | Status |
|---|---|---|---|---|
| 1. Plan & Implement | 20-25% | 6 pages | 11 topics | ✅ Complete |
| 2. Security | 15-20% | 4 pages | 12 topics | ✅ Complete |
| 3. Monitor & Optimize | 20-25% | 4 pages | 11 topics | ✅ Complete |
| 4. Automation | 10-15% | 6 pages | 8 topics | ✅ Complete |
| 5. HA/DR | 20-25% | 6 pages | 16 topics | ✅ Complete |
| Total | 100% | 26 pages | 58 topics | ✅ All covered |
Tag Legend
| Tag | Meaning |
|---|---|
| 🎯 Core Exam | Heavily tested on DP-300. Study this thoroughly. |
| 📖 Deep Dive | Important for real-world, occasionally tested. Good to understand deeply. |
| 📚 Reference | Background knowledge. Unlikely to appear directly on exam but useful context. |
Additional Study Resources
| Resource | URL |
|---|---|
| Official DP-300 exam page | Microsoft Learn — DP-300 |
| DP-300 learning path | Microsoft Learn — DP-300T00 |
| Azure SQL documentation | Microsoft Learn — Azure SQL |
| Practice assessment | Microsoft Learn — Practice Assessment |