How hard is DP-300? +
DP-300 is hard because the right answer often depends on which Azure SQL option you are running - SQL Database, SQL Managed Instance or SQL Server on a VM. HA/DR features, automation tools and some security features differ across them. Cloud-first admins also tend to lack the SQL engine depth needed for Query Store, DMVs and execution plan questions.
What does DP-300 cover? +
The main areas include a secure environment (20-25%), monitoring and optimizing (20-25%) and high availability and disaster recovery (20-25%), along with planning resources and automating tasks. Expect questions on failover groups, availability groups, Always Encrypted, row-level security, ledger, Resource Governor and elastic jobs. Use the current Microsoft Learn study guide for exact weights.
What is the DP-300 format and passing score? +
Expect roughly 40-60 questions in about 100 minutes, proctored online or at a Pearson VUE center. Question types include multiple choice, drag-and-drop, hot-area items and case studies. You need 700 on a scaled 1 to 1000 scale, which is not the same as 70% correct.
How much does DP-300 cost and how do I keep the certification? +
The exam costs $165 in the US, and pricing varies by country. Passing earns the Azure Database Administrator Associate certification, which is valid for one year. You renew for free by passing an online assessment on Microsoft Learn within the six months before expiry. No full exam retake is needed.
How long should I prepare for DP-300? +
Experienced SQL Server DBAs usually need 4-6 weeks, mostly on Azure-specific deployment options, Entra authentication and automation. Azure admins without deep SQL Server experience should allow 8-10 weeks and practice Query Store, Extended Events and execution plans on a real database. A free Azure SQL Database or Managed Instance trial is enough for most hands-on practice.
What is the DP-300 retake policy? +
If you fail a Microsoft exam, you can retake it after 24 hours. After that, each further retake requires a 14-day wait, with a maximum of five attempts in any 12-month period. Your score report lists performance by skill area, so use it to focus the next attempt.