Microsoft Azure Database Administrator AssociateStudy guide
The associate certification for deploying, operating, and optimizing SQL databases on Azure (DP-300).
About Microsoft Azure Database Administrator Associate (DP-300)
Microsoft Azure Database Administrator Associate (DP-300) is a Associate-level certification from Microsoft. This page organizes the exam scope into a 5-chapter, 11-section study guide and lets you check your understanding with exam-style practice questions. A good flow is to read the chapters below in order, then test yourself via "Practice questions."
Exam domains (approximate weighting)
- Plan and implement data platform resources~23%
- Implement a secure environment~18%
- Monitor, configure, and optimize database resources~23%
- Configure and manage automation of tasks~18%
- Plan and configure high availability and disaster recovery~18%
Weights are approximate guidance for the live exam. Each domain is covered in detail in the chapters and sections below.
Official exam information: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-300
1Plan and Implement Data Platform Resources
- 1.1SQL Deployment Options in Azure
Understand the three options for running SQL on Azure—Azure SQL Database (PaaS), Azure SQL Managed Instance (PaaS, high compatibility), and SQL Server on Azure VM (IaaS)—and how to choose. The starting point for DP-300.
- 1.2Service Tiers and Scaling
Understand Azure SQL service tiers—General Purpose, Business Critical, and Hyperscale—plus scaling via vCore/DTU, serverless, and elastic pools.
- 1.3Database Migration and Provisioning
Understand migration to Azure SQL (Azure Database Migration Service, compatibility assessment, offline/online) and automated provisioning (ARM/Bicep, CLI).
2Implement a Secure Environment
- 2.1Authentication and Access Control
Understand Azure SQL authentication (Microsoft Entra authentication and SQL authentication) and in-database authorization (roles, least privilege). Securely control who can access what.
- 2.2Data Encryption and Auditing
Understand Azure SQL encryption at rest (TDE), Always Encrypted for client-side column protection, dynamic data masking, auditing, and Microsoft Defender for SQL.
3Monitor, Configure, and Optimize Database Resources
- 3.1Monitoring and Performance Visibility
Understand monitoring Azure SQL—metrics (DTU/CPU/IO), Azure Monitor / Log Analytics, Query Store, and dynamic management views (DMVs)—to find performance bottlenecks.
- 3.2Query and Index Optimization
Understand reading execution plans, indexes (missing/unused/fragmentation), statistics, and optimization via automatic tuning and intelligent query processing. After measuring comes improving.
4Configure and Manage Automation of Tasks
- 4.1Automating Tasks with Jobs
Understand ways to automate routine operations—SQL Server Agent (VM/Managed Instance), Elastic Jobs (Azure SQL Database, across many DBs), and Azure Automation. The mechanism depends on the deployment.
- 4.2Configuring Alerts and Notifications
Understand alerts that fire on metric/log conditions, action groups for notification/automated response, and notifications on job failures. Detect issues early and respond automatically to stabilize operations.
5Plan and Configure High Availability and Disaster Recovery
- 5.1Backup and Restore
Understand Azure SQL automated backups and point-in-time restore (PITR), long-term retention (LTR), geo-restore, and retention (RPO/RTO concepts). The basis of recovering from data loss.
- 5.2High Availability and Disaster Recovery Strategies
Understand Azure SQL zone redundancy (in-region HA), active geo-replication and failover groups (cross-region DR), and Always On availability groups (VM). Design to RPO/RTO requirements.