Microsoft · 2026 Edition
A complete preparation guide written by Microsoft-certified engineers. Covers the exam format,all 6 blueprint domains, a week-by-week study plan, and proven tips for passing first time.
3–4 months
Prep time
Intermediate
Difficulty
50
Exam questions
700/1000
Pass mark
Exam code
DP-300
Full name
Azure Database Administrator Associate
Vendor
Microsoft
Duration
120 minutes
Questions
50 items
Passing score
700/1000 (scaled)
Domains covered
6 blueprint domains
Recommended experience
2+ years of database administration experience; SQL Server or Azure SQL knowledge
Typical prep time
3–4 months
DP-300 earns the Azure Database Administrator Associate certification. It validates skills to manage relational database services on Azure — a role that exists at nearly every enterprise operating an Azure data platform.
Job roles this opens
Domain percentage weights are not currently available for this exam. The checklist below is still useful for planning your study.
Weeks 1–2
Plan and Implement Data Platform Resources: Azure SQL options, pricing tiers, DTUs vs vCores
Tip: Azure SQL service tiers: General Purpose (balanced compute/storage), Business Critical (in-memory OLTP, local SSD, readable secondary), Hyperscale (up to 100TB, rapid scaling). Business Critical is the only tier with a local replica that eliminates I/O latency for log writes.
Weeks 3–5
Secure Environments: authentication, authorisation, network isolation, auditing
Tip: Azure SQL authentication options: SQL authentication (username/password), Microsoft Entra authentication (recommended), and certificate-based service principal authentication for applications. Microsoft Entra-only authentication can be enforced at the server level to block SQL auth entirely.
Weeks 6–8
Monitor and Optimise: Query Store, performance baselines, indexing, wait stats
Tip: Query Store is the most tested performance tool on DP-300. Know how to identify regressed queries (queries that got slower after a change), force a query plan, and use the Top Resource Consuming Queries report. Query Store is enabled by default in Azure SQL Database.
Weeks 9–12
Automate, HA/DR: Elastic Jobs, Azure Automation, geo-replication, failover groups
Tip: Failover groups extend active geo-replication by providing a read/write listener DNS name that automatically redirects to the primary replica. Know the difference between manual failover and automatic failover, and what the grace period setting controls.
T-SQL for DBA administration is tested: know how to use sys.dm_exec_query_stats, sys.dm_exec_sessions, sys.dm_os_wait_stats to diagnose performance issues. You will not write complex application queries but must read and interpret DMV output.
Azure SQL Managed Instance is the most SQL Server-compatible option — it supports SQL Server Agent, linked servers, CLR, cross-database queries, and most SSMS features. Know when a customer needs Managed Instance vs Azure SQL Database.
Intelligent Query Processing (IQP) automatically improves query performance in SQL Server 2019+ and Azure SQL: adaptive joins, interleaved execution, table variable deferred compilation, and scalar UDF inlining. Enabled at database compatibility level 150+.
Transparent Data Encryption (TDE) encrypts the database, backups, and transaction log files at rest. Azure SQL Database enables TDE by default. Customer-managed keys (BYOK) via Azure Key Vault are an option for compliance-sensitive workloads.
Long-term backup retention (LTR) stores weekly, monthly, or yearly backups in Azure Blob Storage for up to 10 years. Know the difference between automatic backups (7–35 days, managed by Azure) and LTR backups (configured separately, for compliance).
Apply everything in this guide with adaptive practice questions, detailed answer explanations, and domain analytics.
Deep-dive explanations of the key topics tested on DP-300 — with exam key points and common misconceptions.