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.
Last verified against MS Learn
April 28, 2026 - aligned with the official DP-300 study guide (Skills measured as of April 24, 2026). Domain weights and skills below match the published version.
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 | Azure SQL Options | SQL DB vs MI vs VM - which is your Oracle replacement |
| 3 | vCore vs DTU | Purchasing models (no Oracle equivalent) |
| 4 | HA/DR Overview | Data Guard -> Failover Groups, RAC -> BC Tier |
| 5 | Performance Tuning | AWR -> Query Store, ASH -> DMVs |
| 6 | 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 (15-20%)
| 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 |
| Azure Arc-enabled SQL services (use cases) | Arc & Fabric SQL | Covered | Core Exam |
| Azure SQL Database in Microsoft Fabric (use cases) | Arc & Fabric SQL | Covered | Core Exam |
| Table partitioning (plan + configure) | Partitioning & Compression | Covered | Core Exam |
| Database sharding (recommend) | Partitioning & Compression | Covered | Deep Dive |
| Data compression (row, page, columnstore) | Partitioning & Compression | Covered | Core Exam |
| Migration strategies (DMS, BACPAC, SSMA) | Migration Strategy | Covered | Core Exam |
| MI database copy and move | Migration Strategy | Covered | Core Exam |
| Hybrid SQL Server deployments & IaaS patching | SQL VM Configuration | Covered | Deep Dive |
| PostgreSQL & MySQL on Azure | PostgreSQL & MySQL | Covered | Reference |
| SQL IaaS Agent Extension | SQL VM Configuration | Covered | Deep Dive |
Domain 2: Implement a Secure Environment (20-25%)
| Topic | Page | Status | Tag |
|---|---|---|---|
| SQL Auth vs Entra ID vs Managed Identity | Authentication & Authorization | Covered | Core Exam |
| Database roles & permissions (least privilege) | Authentication & Authorization | Covered | Core Exam |
| Manage authN/authZ by T-SQL | Authentication & Authorization | Covered | Core Exam |
| Row-Level Security & Dynamic Data Masking | Authentication & Authorization | Covered | Core Exam |
| TDE (at rest) | Encryption & Network | Covered | Core Exam |
| Object-level encryption (cell/column) | Encryption & Network | Covered | Deep Dive |
| Always Encrypted (in use) | Encryption & Network | Covered | Core Exam |
| Always Encrypted with VBS enclaves | Always Encrypted with VBS Enclaves | Covered | Core Exam |
| TLS (in transit) | Encryption & Network | Covered | Deep Dive |
| Azure Key Vault integration | Encryption & Network | 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 |
| Data classification strategy | Compliance & Security | Covered | Core Exam |
| Change Data Capture (CDC) / Change Tracking | Compliance & Security | Covered | Core Exam |
| Vulnerability Assessment | Compliance & Security | Covered | Deep Dive |
| Database Ledger | Compliance & Security | Covered | Reference |
Domain 3: Monitor, Configure, and Optimize Database Resources (20-25%)
| Topic | Page | Status | Tag |
|---|---|---|---|
| Performance baseline + metric sources | Performance Tuning | Covered | Core Exam |
| 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 |
| Identify and resolve session blocking | Performance Tuning | Covered | Core Exam |
| Automatic Tuning | Azure SQL DB Config | Covered | Core Exam |
| Intelligent Query Processing (IQP) | 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 |
| Index maintenance tasks | Index Design & Tuning | Covered | Core Exam |
| Statistics maintenance tasks | Index Design & Tuning | Covered | Core Exam |
| Database integrity checks (DBCC CHECKDB) | Advanced Monitoring | Covered | Core Exam |
| Database-scoped configuration | Azure SQL DB Config | Covered | Core Exam |
| Server settings for performance | Advanced Monitoring | Covered | Deep Dive |
| Extended Events | Advanced Monitoring | Covered | Deep Dive |
| Database Watcher | Database Watcher | Covered | Core Exam |
| Intelligent Insights | 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 (15-20%)
| Topic | Page | Status | Tag |
|---|---|---|---|
| SQL Server Agent jobs (schedules, alerts, troubleshoot) | 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 |
| Deployment via ARM & Bicep templates | Deployment Automation | Covered | Core Exam |
| Deployment via Azure PowerShell | Az CLI & PowerShell Deployment | Covered | Core Exam |
| Deployment via Azure CLI | Az CLI & PowerShell Deployment | Covered | Core Exam |
| Monitor & troubleshoot deployments | Az CLI & PowerShell Deployment | Covered | Core Exam |
| DACPAC / SqlPackage | Deployment Automation | Covered | Deep Dive |
| Alerts & Action Groups on database tasks | 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 |
| Backup/restore using T-SQL (incl. cloud storage) | 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 |
| HA/DR for hybrid deployments | HA/DR Testing & Troubleshooting | Covered | Core Exam |
| Plan a testing procedure for HA/DR | HA/DR Testing & Troubleshooting | Covered | Core Exam |
| Monitor & troubleshoot HA/DR | HA/DR Testing & Troubleshooting | 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 | Topics | Status |
|---|---|---|---|---|
| 1. Plan & Implement | 15-20% | 8 pages | 18 topics | Complete |
| 2. Security | 20-25% | 5 pages | 17 topics | Complete |
| 3. Monitor & Optimize | 20-25% | 5 pages | 20 topics | Complete |
| 4. Automation | 15-20% | 7 pages | 12 topics | Complete |
| 5. HA/DR | 20-25% | 7 pages | 19 topics | Complete |
| Total | 100% | 32 pages | 86 topics | Aligned with Apr 24, 2026 skills |
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. |
Advanced Labs
Hands-on labs built from real customer engagements. Each deploys real Azure infrastructure and teaches production skills.
| Lab | Domain | Skills Practiced | Time |
|---|---|---|---|
| AlwaysOn HA Setup | D5: HA/DR | WSFC, AG, ILB listener, automatic failover | ~2 hrs |
| Cross-Region AlwaysOn | D5: HA/DR | Multi-region AG, async commit, VNET peering, forced failover | ~1 hr |
| SQL MI Flavors & Replicas | D1 + D5 | GP vs BC tiers, read replicas, MI failover groups | ~6 hrs |
| SQL Security Assessment | D2: Security | TDE, auditing, sensitive data discovery, risk scoring | ~30 min |
| SQL Migration Lab | D1: Plan & Implement | Backup to URL, blob restore, IaaS Agent extension | ~1 hr |
| Azure SQL DB Tiers | D1 + D3 | DTU vs vCore, GP/BC/HS, Serverless, Elastic Pool benchmarks | ~30 min |
| Migration Scenarios | D1: Plan & Implement | BACPAC, DMS Online, MI Link, LRS, replication - all 6 paths | ~4 hrs |
| Geo-Replication & Failover | D5: HA/DR | Geo-replication, failover groups, RPO/RTO measurement | ~45 min |
| Performance Troubleshooting | D3: Monitor & Optimize | Query Store, DMVs, wait stats, plan forcing, blocking | ~1 hr |
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 |