Microsoft Azure Database Administrator Associate
DP-300 validates administering SQL Server and Azure SQL database platforms: planning and deploying data-platform resources, implementing a secure environment, monitoring and optimizing resources, automating tasks, planning and implementing high availability and disaster recovery, and performing administration with T-SQL.
Ready to sit the mock exam?
The timer starts as soon as you begin. You can flag questions, move freely between them, and review everything before submitting. No sign-in required — sign in afterwards to save the result to your history.
Start DP-300 examSkills measured
Plan and Deploy Data Platform Resources
20%Deployment options (SQL Database, Managed Instance, SQL on VMs), sizing and service tiers, and migrating and provisioning with ARM/Bicep.
Implement a Secure Environment
15%Authentication with Microsoft Entra ID, authorization and roles, row-level security, dynamic data masking, TDE and Always Encrypted, and auditing.
Monitor, Configure and Optimize Resources
20%Monitoring with Azure Monitor and DMVs, query performance insight, intelligent performance, index and statistics maintenance, and query tuning.
Configure and Manage Automation of Tasks
15%SQL Server Agent jobs, elastic jobs, Azure Automation, and alerts and notifications.
Plan and Implement High Availability and Disaster Recovery
20%Backup and restore, failover groups, active geo-replication, availability groups, and recovery objectives.
Perform Administration Using T-SQL
10%Configuration, monitoring queries, permissions and backups via T-SQL.