SQLMentor // cert practice
← All certifications
// DP-300 practice

Microsoft Azure Database Administrator Associate (DP-300)

Timed practice exams modelled on the Microsoft Azure Database Administrator Associate (DP-300) certification. Each set has 30 questions and a 60-minute window. Two difficulty tiers — Foundations and Advanced — covering Azure SQL deployment, HA/DR, performance, and security.

30questions per set
60minute timer (auto-submit)
70%passing score
2practice sets

About this certification

The Microsoft Azure Database Administrator Associate (DP-300) is Microsoft's role-based certification for DBAs managing relational databases on Azure. It validates that you can plan, implement, secure, monitor, optimise, automate, and recover SQL Server and Azure SQL workloads at scale — required for many cloud DBA roles in enterprises moving to Azure.

View on Microsoft Learn ↗

Exam format

  • Questions: 40–60 multiple choice (varies)
  • Duration: 100 minutes
  • Pass mark: 700 / 1000 (≈ 70%)
  • Delivery: Pearson VUE or online proctored
  • Cost: US$165 (varies by region)
  • Languages: English, Japanese, Chinese, Korean, German, French, Spanish
Topics covered & study plan

Topics covered

Five skill areas: Plan & implement data platform resources (Azure SQL deployment, vCore vs DTU, service tiers); Implement a secure environment (Azure AD, TDE, Always Encrypted, RLS, DDM, auditing); Monitor, configure & optimise (DMVs, Query Store, automatic tuning); Configure automation (Elastic Jobs, Azure Automation, SQL Agent on Managed Instance); Plan & configure HA/DR (failover groups, geo-replication, Always On AGs, backup/restore).

Recommended study plan

  1. Complete the official Microsoft Learn DP-300 learning path (free).
  2. Provision an Azure SQL Database trial and an Azure SQL Managed Instance evaluation.
  3. Practise every CLI command from az sql — don't just memorise.
  4. Take Practice Set 1 under timing and review wrong answers.
  5. For each wrong answer, re-read the relevant Microsoft Learn module.
  6. Repeat Practice Set 2 a week later; aim for ≥ 75% consistently.

Pick a set to begin

Loading exam sets…
How the exam works
  • The 60-minute timer starts the moment you click Start exam.
  • Use the question grid to jump between questions; flag any you want to revisit.
  • Click Submit exam at any time to finish early; if the timer reaches zero, the exam auto-submits.
  • After submission you'll see your score, pass/fail status, weak topics, and per-question feedback.
  • Start with Foundations to build Azure SQL fundamentals, then progress to Advanced for HA/DR and performance topics.
  • Your progress is kept in the browser only — refreshing during an exam will reset it.

Frequently asked questions — DP-300

How many questions are on the DP-300 exam?
The DP-300 exam contains 30 multiple-choice questions to be answered in 60 minutes. SQLMentor's free practice sets mirror that format so the timing feels familiar on exam day.
What is the passing score for DP-300?
The official passing score for the DP-300 exam is 70%. Each SQLMentor practice set is scored against that same threshold and shows a clear PASS or FAIL on the results screen.
How long should I prepare for the DP-300 exam?
Most candidates prepare for 4 to 8 weeks with consistent daily study. We recommend reading through the SQLMentor tutorials first, then running timed practice sets in the final two weeks until you score above 70% consistently.
Is the SQLMentor DP-300 practice exam free?
Yes. Every DP-300 practice set on SQLMentor is 100% free with no sign-up, no email gate and no paywall. Your progress is saved locally in your browser.
What topics does DP-300 cover?
Azure SQL deployment, security, monitoring, performance tuning, high availability, disaster recovery and automation across Azure SQL Database, Managed Instance and SQL Server on Azure VMs. The SQLMentor sets are organised so each set samples across all of these areas to give you a realistic mix on every attempt.