Microsoft Certified: Azure Database Administrator Associate (DP-300)

The DP-300 exam is designed for Azure Database Administrators who manage on-premises and cloud databases built with SQL Server and Azure SQL services. Candidates should be proficient in:

• SQL Server on-premises
• Azure SQL Database
• Azure SQL Managed Instance
• SQL Server on Azure VMs

Skills Measured (as of October 25, 2024)

1. Plan and implement data platform resources (20–25%)
   • Deploying Azure SQL solutions
   • Configure resources for scale/performance
   • Plan and implement migration strategies
2. Implement a secure environment (15–20%)
   • Configure authentication/authorization
   • Implement encryption and data protection
   • Apply compliance controls
3. Monitor, configure, and optimize database resources (20–25%)
   • Monitor performance using tools like Query Store, SQL Insights, and Database Watcher
   • Optimize queries and indexes
   • Configure automatic tuning
4. Configure and manage automation of tasks (15–20%)
   • Use SQL Server Agent, Azure Automation, ARM/Bicep templates
   • Create elastic jobs and alerts
5. Plan and configure high availability and disaster recovery (HA/DR) (20–25%)
   • Recommend HA/DR strategies
   • Configure geo-replication, failover groups, Always On availability groups
   • Perform backups and restores

Study Resources

• Certification Page: Microsoft Certified: Azure Database Administrator Associate
• Practice Assessment: DP-300 Practice Assessment
• Official Study Guide: Microsoft Learn DP-300 Study Guide
• Overview & Tips: Data Exposed – DP-300 Exam Overview
• Video Series: Exam Readiness Zone DP-300 (5 Videos)