DP-300: Diagnose the signal.
Practise the next database decision.
Rehearse Azure SQL deployment, security, performance, automation, and recovery decisions. Your results highlight which database skill to revisit next.
425 practice questions
AI score prediction
100% offline
Download free
iPhone & iPad · Free to startOn your Mac? Scan to install
DP-300Microsoft Azure Database Administrator
DP-300 · 30 days left ›
PREDICTED786 ±37✓ Exam Ready · 87% confidence
DP-300 Practice Questions & Exam Prep — Microsoft Azure Database Administrator
Prepare for DP-300 (Microsoft Azure Database Administrator) on iPhone or iPad with scenarios that connect symptoms to the right Azure SQL action. Track readiness across all five domains, identify whether deployment, security, monitoring, optimisation, or recovery needs attention, and turn each result into a focused next session. Core study works offline on your device; optional sync uses your private iCloud account.
The exam
What is the DP-300 exam?
DP-300 is the Microsoft Certified: Azure Database Administrator Associate exam — the credential hiring managers expect when posting "Database Administrator", "Azure SQL DBA", or "Cloud Database Engineer" roles on the Microsoft data platform.
It's the natural next step after DP-900 for anyone whose day job has shifted from generalist data work into running and securing SQL workloads in production. DP-300 is the only Microsoft Associate cert dedicated to operating the SQL family on Azure.
DP-300 is hands-on and operational. It validates that you can:
Plan and implement Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure VMs
Secure data with Microsoft Entra authentication, Always Encrypted, dynamic data masking, row-level security, TDE, and Microsoft Defender for SQL
Tune workloads via Query Store, automatic tuning, indexes, partitioning, and Resource Governor
Automate operations with SQL Agent, elastic jobs, PowerShell, and ARM/Bicep
Design HA/DR with Always On availability groups, geo-replication, auto-failover groups, and PITR
Expect scenario questions that show you a query plan, a config snippet, or a recovery requirement and ask what you'd do.
Microsoft updated the DP-300 skills outline on 24 April 2026. Every question in Azure Mastery's DP-300 bank is mapped to the current outline — no leftover questions on retired services. Read the official outline at learn.microsoft.com.
Prepare by building a deployment-target matrix rather than memorising one undifferentiated list of SQL features. Track what changes between Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VMs, and Azure Arc-enabled SQL Server: who owns patching, which job scheduler is available, where instance-level features live, and which identity crosses each control-plane boundary. Then connect operational evidence to the right tool — Query Store for performance history, Extended Events for event-level symptoms, elastic-job history for fleet automation, and backup or restore telemetry for recovery. That comparison habit is what turns DP-300's long scenarios into a small set of supportability, security, and recovery decisions.
Questions40–60 multiple choice
Duration100 minutes (120 min seat)
Pass score700 / 1000
CostUSD $165 (≈ £128 UK)
ValidityRenew annually (Associate)
FormatOnline or test centre
Practise the DBA loop
Turn each DP-300 topic into an operational decision
Start with one small workload and move it through the same sequence a database administrator owns in production. Choose its deployment target, document the service boundary, configure identity and encryption, collect a performance baseline, automate a repeatable task, and then prove how the database recovers. Keeping one workload throughout makes the trade-offs visible: an elastic job is not a renamed SQL Server Agent job, a database-scoped Extended Events session is not a server trace, and a failover-group listener solves a different operational problem from a manually failed-over geo-replica.
Keep the evidence beside the decision. Save the query plan that justified an index, the Query Store interval that exposed a regression, the job execution row that explained a failed target, and the recovery-point and recovery-time numbers used to choose a continuity design. DP-300 scenarios often supply several technically valid features; the answer becomes clear only when you tie the requirement to the observable signal and the deployment target that supports it.
Finish each lab by changing one constraint. Require the encryption key to remain outside the database engine, remove direct network access to the job database, delay restores on a log-shipping secondary, or place SQL Server under Azure Arc management. Re-evaluating the design after a single constraint changes trains the exam skill that matters most: explaining why a familiar SQL feature is right in one operating model and wrong in another.
Skills measured · 24 April 2026
DP-300 exam objectives
Five domains, with weights set by Microsoft's 24 April 2026 update. Every domain below lists Microsoft's own skill groups verbatim from the official skills outline, and Azure Mastery tags each question to its assessed domain so you can see which topics need more practice.
Data skill mapSourcesTransformStoreAnalyse
Plan and implement data platform resourcesPublished weight 15–20%
77 exam-scoped practice questions in the app
Explore Platform topics
Plan and deploy Azure SQL solutions
Configure resources for scale and performance
Plan and implement a migration strategy
Tests choosing the right SQL deployment target and sizing its compute, storage, and scaling for the stated need.
Candidates default to Azure SQL Database out of habit, even when the scenario names an instance-scoped feature only Managed Instance supports.
Match the migration mode, online or offline, to the downtime the scenario says the business can tolerate.
Implement a secure environmentPublished weight 20–25%
96 exam-scoped practice questions in the app
Explore Security topics
Configure database authentication and authorization
Implement security for data at rest and data in transit
Implement compliance controls for sensitive data
Matching an authentication, encryption, or compliance control to a named requirement across the three SQL deployment targets is the core ask.
Transparent Data Encryption often gets reached for when the scenario actually needs Always Encrypted to hide data from a privileged DBA.
Ask whether the requirement is protecting data at rest or hiding it from an authorised administrator before picking an encryption feature.
Monitor, configure, and optimize database resourcesPublished weight 20–25%
92 exam-scoped practice questions in the app
Explore Monitoring topics
Monitor resource activity and performance
Monitor and optimize query performance
Configure database solutions for optimal performance
Tests reading a query plan, wait type, or metric and picking the tool built to diagnose that specific symptom.
Candidates reach for a dynamic management view when the scenario needs history that survives a restart or failover.
Use Query Store for a regression that developed over time; use DMVs or Extended Events for what's happening right now.
Configure and manage automation of tasksPublished weight 15–20%
72 exam-scoped practice questions in the app
Explore Automation topics
Create and manage SQL Server Agent jobs
Automate deployment of database resources
Create and manage database tasks in Azure
Which automation tool is even available on the named deployment target is what trips people up first.
SQL Server Agent is often assumed to run everywhere, but a single Azure SQL Database has no built-in Agent at all.
Reach for an elastic job the moment a scenario names scheduled T-SQL running across a fleet of Azure SQL databases.
Plan and configure a high availability and disaster recovery (HA/DR) environmentPublished weight 20–25%
88 exam-scoped practice questions in the app
Explore HA/DR topics
Plan an HA/DR strategy for database solutions
Plan and perform backup and restore of a database
Configure HA/DR for database solutions
Matching an HA/DR feature to the stated recovery-time and recovery-point numbers matters more than recognising a familiar service name.
Active geo-replication gets picked when the scenario actually wants a failover group's automatic failover behind one listener.
Work out the RPO and RTO the scenario states first, then choose the HA/DR feature built to hit both numbers.
Common traps
Where DP-300 candidates slip
Five recurring misconceptions that trip up otherwise well-prepared DP-300 candidates, grounded in the current skills outline.
Azure SQL Database doesn't expose the instance-scoped feature set of SQL Server or Managed Instance.
Linked servers, SQL Server Agent, and CLR are strong signals to consider Managed Instance or SQL Server on an Azure VM.
Cross-database access is possible through Elastic Query external tables, not ordinary three- or four-part names.
TDE and Always Encrypted stop different people from reading your data.
TDE hides data from someone stealing the files; it does nothing to stop a DBA running a query.
Pick Always Encrypted specifically when the requirement says even a privileged administrator must not see the values.
Geo-replication and failover groups solve the same problem with different guarantees.
Automatic, transparent failover belongs to a failover group; manual control is what geo-replication actually offers.
Read the failover requirement for the word "automatic" before choosing between the two options.
Dynamic management views reset on every restart or failover.
Query Store, not a DMV, is what holds history that survives a restart.
Save DMVs for a live, in-the-moment symptom and Query Store for anything asking about change over time.
Azure SQL Database has no built-in SQL Server Agent.
Elastic Jobs is Azure SQL's managed service for running scheduled T-SQL across databases; external schedulers are another option.
Confirm the deployment target first: SQL Server Agent is available on Managed Instance and SQL Server on Azure VMs, while Elastic Jobs targets Azure SQL Database.
Designed for DP-300
How Azure Mastery helps you pass DP-300
Exam-specific practice
425 DP-300 practice questions, each written against the current 24 April 2026 skills outline.
Every question carries a tag for one of DP-300's five official domains.
Practise reading a T-SQL snippet, config value, or recovery requirement, the exam's actual scenario style.
Predicted score
Exam IQ forecasts your DP-300 score on-device after roughly 30 questions, with a confidence range attached.
It names the specific security, monitoring, or HA/DR topic dragging your score down.
It flags which of the five domains is weakest before you book the exam.
Adaptive study plan
Your plan leans hardest on security and HA/DR, the two domains Microsoft weights joint-heaviest at 20–25%.
Miss an Always Encrypted vs TDE question and the next session surfaces that distinction again.
Three clean sessions on a topic and the plan quietly drops it from rotation.
Knowledge decay
Five domains is a lot to retain, so a topic mastered early can fade by exam day if you stop revising it.
A padlock icon appears on the Today screen once a topic starts to fade.
Focus Weak Spots sessions pull decayed topics to the front automatically.
Exam rehearsal
Sit a full 100-minute session with no going back once you've moved past a question.
Question selection follows the published domain weights, all original, none lifted from Microsoft.
The live DP-300 interface and question mix are Microsoft's to control, not ours.
Answer Coach
Untangles DP-300's near-identical calls: Always Encrypted vs TDE, active geo-replication vs auto-failover groups.
Each note names the property of the scenario that should have driven your choice.
On capable hardware a note can be reworded on-device, but only after it's checked against the source guidance.
Aura guidance
Aura adjusts what it suggests as your first week of DP-300 sessions goes on.
Each session closes with a short recap: what moved, what to revisit, what comes next.
Private by design
Your DP-300 answer history, readiness gauge, and Answer Coach notes stay private by default.
There's no Azure Mastery account and no server in the loop at all.
Optional sync uses your private iCloud account.
6-week study plan
Suggested DP-300 study plan
Work through SQL deployment, security, performance and recovery. Follow these six weeks of study blocks, then review your progress with timed practice.
Choose a SQL platform
Compare SQL Database, Managed Instance and SQL Server on VMs.
Review tiers, elastic pools and Hyperscale.
Plan compute, storage, scaling and deployment tooling.
Plan migrations
Compare Database Migration Service and Azure Migrate.
Choose online or offline migration.
Review schema and data migration tools.
Authentication and roles
Compare Entra and SQL authentication.
Review contained users, server roles and database roles.
Distinguish Azure resource RBAC from database permissions.
Protect data and access
Compare TDE, Always Encrypted, masking and row-level security.
Review auditing and Defender for SQL.
Configure firewall, virtual network and Private Link access.
Monitor SQL performance
Explore Query Store and automatic tuning.
Review Intelligent Insights and Performance Monitor.
Use dynamic management views to investigate performance.
Indexes and statistics
Compare clustered, non-clustered and columnstore indexes.
Review filtered indexes and included columns.
Manage statistics, fragmentation and index maintenance.
Tune workload behaviour
Review partitioning, In-Memory OLTP and Resource Governor.
Analyse query plans.
Investigate blocking and deadlocks.
Automate administration
Compare SQL Agent and elastic jobs.
Review scripts, Logic Apps and Automation runbooks.
Use ARM/Bicep and Azure Monitor alerts.
SQL VM availability
Compare synchronous and asynchronous availability groups.
Review read-only routing and listeners.
Explore failover cluster instances.
Managed-service recovery
Compare geo-replication, failover groups and zone redundancy.
Review point-in-time restore, retention and geo-restore.
Match recovery options to RPO and RTO needs.
Target weaker topics
Run Focus Weak Spots sessions.
Balance revision across the domains.
Review explanations for missed scenarios.
Timed rehearsal
Complete two 100-minute Exam Simulator sessions.
Review each run carefully.
Use the results to plan further study.
Inside the app
Nine interactive practice formats, on iPhone
Practise DP-300 through nine interactive formats covering Azure SQL architecture, access control, monitoring signals, query tuning, automation, and recovery. The examples below are original questions from Azure Mastery on iPhone and iPad. Timed simulations follow the published domain weights; Microsoft's live interface and question mix may differ.
Which Query Store wait category aggregates CPU waits such as SOS_SCHEDULER_YIELD?
Buffer IO
CPU
Lock
Preemptive
Multiple choice
An original DP-300 practice question with one correct answer. The app explains every option after you answer.
Exam-specific sample
Which capture modes are valid for Query Store QUERY_CAPTURE_MODE? (Choose three.)
ADHOC_ONLY
AUTO
CUSTOM
ALL
Multi-select
An original DP-300 multi-select question. Select all the correct options to earn the mark.
All-or-nothing
Order the steps to recover a database to a point in time just before an accidental change.
⋮⋮1Identify the exact time just before the accidental change
⋮⋮2Confirm the change is within the configured backup retention window
⋮⋮3Start a point-in-time restore to a new database at the chosen timestamp
⋮⋮4Validate the restored database contains the expected data
Drag-and-drop
An original DP-300 ordering question you can answer by touch on iPhone and iPad.
Interactive item
On the Azure SQL Database Security blade, select the settings you would use to (1) restrict access to a specific IP range, (2) review suggested sensitive-column…
Hotspot
An original DP-300 question with a visual prompt, designed for touch on iPhone and iPad.
Tap target
Coho Vineyard — Securing a regulated Azure SQL database Coho Vineyard stores regulated customer data in Azure SQL Database. An audit found SQL logins with stored passwords, sensitive columns readable by DBAs, and no auditing…
1How should the application authenticate to Azure SQL without a stored password?
2Which feature keeps the national-ID column unreadable even to a DBA?
3How can the database ensure each regional manager sees only their region's rows?
4Which feature shows support staff a masked identifier without changing the…
Case studies
An original DP-300 case study with several questions about the same requirements and environment.
Multi-question
✕Your answer: Buffer IO
✨ Answer Coach:The Buffer IO wait category aggregates page-read waits like PAGEIOLATCH; CPU-scheduler waits such as SOS_SCHEDULER_YIELD fall under the CPU category.
— grounded in authored certification guidance
Answer Coach
Answer Coach explains why the answer is correct and, where available, why each option is right or wrong. It helps you understand a mistake and remember the distinction. Read explanations after each question or at the end of a practice test. On supported devices, optional AI can reword a note on your device after checking it against the written guidance.
App exclusive
Frequently asked
DP-300 FAQs
DP-300 vs DP-900 — which should I take first?
DP-900 first if databases aren't already your day job. DP-900 teaches the data vocabulary — relational vs non-relational, OLTP vs OLAP — without expecting T-SQL. DP-300 is the role-based Associate exam: it expects you to run Azure SQL workloads in production.
Auto-failover group or active geo-replication — which does DP-300 want?
Pick an auto-failover group when the requirement is automatic, transparent failover behind a stable listener endpoint. Pick active geo-replication when the requirement is manual control over failover timing, or more secondaries than a failover group allows. Naming the wrong one for a stated recovery-time requirement is one of the exam's most repeated misses.
What format does the DP-300 exam use?
40–60 questions, with formats that vary by sitting. Azure Mastery's bank runs a similar spread: mostly single-answer multiple choice, a real slice of scenario-based, drag-to-match, and multi-select questions, and a smaller mix of dropdown-select, yes/no, and hotspot items. T-SQL snippets and config JSON appear throughout.
What's the DP-300 exam fee, and does renewal cost extra?
The voucher is USD $165 in the United States, or around £128 in the UK. Microsoft sometimes runs free-voucher promotions around events like Build or Ignite, so check your Learn profile before booking. Renewal itself is free, but it happens every year.
Is a DP-300 pass permanent, or does it lapse?
It lapses unless renewed. Associate certifications including DP-300 expire annually; renewal is a free, short online assessment on Microsoft Learn within the six months before expiry. Fundamentals certs such as AZ-900 are different — those don't expire at all.
Query Store or Extended Events — which does DP-300 expect for troubleshooting?
Query Store answers a regression over time — a query that used to run fast and now doesn't. Extended Events answers a live, event-level symptom, such as a deadlock, right now. DP-300 names the symptom, not the tool, so matching the two is the real skill.
DP-300 vs AI-300 — different data roles?
They cover different parts of the data stack. DP-300 is for administering Azure SQL workloads in production. AI-300 is for MLOps and GenAIOps across Azure Machine Learning and Microsoft Foundry. Neither is a prerequisite for the other; choose based on the role you're in.
I need to resit DP-300 — how soon can I book again?
Every attempt is a separate booking, and how long you wait depends on which attempt it is.
First retake: after 24 hours.
Second and third retakes: a 14-day wait each.
Cap: five attempts per rolling 12 months.
Can I try Azure Mastery's DP-300 bank before paying?
Yes — the app is free to download, with a free allowance of DP-300 questions so you can try every feature. The full bank of 425 DP-300 practice questions unlocks with a one-time exam-pack purchase, or unlock every exam with a subscription or lifetime upgrade.
Does DP-300 revision still work with no connection?
Yes. The whole loop stays on-device: practice, scoring, and the readiness read. A missing signal doesn't stop a session, and no account is required. Your study data stays local unless you switch on optional private iCloud sync.
Free study guides
Free guides that pair with DP-300
Where DP-300 fits
Certification paths that include DP-300
DP-300 is the Azure Database Administrator Associate cert. It pairs with DP-900 as the recommended fundamentals, and is the only Microsoft Associate cert dedicated to operating the SQL family on Azure. Tap any linked exam below to see its dedicated study app page.
DP-300 sits at the data-platform Associate tier. DP-900 builds the data fundamentals it leans on; AI-300 (MLOps Engineer) and PL-300 (Power BI Data Analyst) provide adjacent role coverage.
Ready to pass DP-300?
Download Azure Mastery free for 425 DP-300 practice questions across deployment, security, monitoring, optimisation, automation, and recovery. Use readiness evidence and timed simulations to choose the next database skill to practise on iPhone or iPad.
