DP-300 practice test
Microsoft Azure Database Administrator Associate
100 practice questions, spread across the exam's topics the same way Microsoft weights them, each with a full explanation and a link to the official documentation that proves the answer. Written by a Microsoft Certified Trainer who does this work for a living.
No card needed to start, and none to keep going: buying is not open yet.
What is inside
Every area the exam tests
Our questions are spread the same way Microsoft weights the exam, so your practice matches the real thing.
Planning and implementing resources
15 to 20%Choosing between the Azure SQL offerings, Arc-enabled services and SQL in Fabric, automated deployment, table partitioning and sharding, hybrid deployments and patching, configuring each offering for scale and performance, compression, and migration onto and between Azure services online and offline.
17 questionsSecuring the environment
20 to 25%Microsoft Entra authentication across the offerings, security principals and least privilege, permissions through tools and T-SQL, transparent and object-level encryption, firewall rules, Always Encrypted and enclaves, private links and service endpoints, classification, auditing, change tracking, masking, ledger and row-level security.
22 questionsMonitoring and optimising
20 to 25%Baselines and where performance metrics come from, database watcher and Extended Events, Query Store, blocking, dynamic management views, indexes and statistics, execution plans, Intelligent Insights, integrity checks, automatic tuning, server settings, Resource Governor, database-scoped configuration, scaling, and intelligent query processing.
22 questionsAutomating tasks
15 to 20%SQL Server Agent jobs, their schedules, alerts and failures, automated deployment through templates, PowerShell and the CLI, monitoring those deployments, elastic jobs, and the alerting and troubleshooting around automated database tasks.
17 questionsHigh availability and recovery
20 to 25%Choosing a strategy from recovery objectives, hybrid and Azure-specific options, testing the plan, backup and restore with native tools and T-SQL, point-in-time and long-term retention, cloud storage, active geo-replication, availability groups, failover groups, failover cluster instances, log shipping, and monitoring what you have built.
22 questionsMicrosoft last updated this exam on 27 October 2026. Our questions match that version.
How you will use it
Practise the way that suits you
- Learn as you go. Answer, read why straight away, then move on. No clock, no pressure.
- Or sit it timed. A clock, no answers until the end, and two minutes a question, so you learn to pace yourself.
- Score by topic. See which area let you down instead of one number out of a hundred.
- Go back over it. Read every question again afterwards, right and wrong, with the full explanation.
Is it for you
Who takes DP-300
Database administrators moving to Azure
It assumes you know SQL Server and asks what changes when the platform runs it for you.
People who own a production database and its uptime
A fifth of the exam is high availability, backup and recovery, and it asks about the design rather than the buttons.
Engineers who inherited a database nobody administers
Monitoring, tuning and automating the routine work is another fifth, and it is where the job actually is.
Also worth doing
Other exams in the same area
See the questions before you pay
10 DP-300 questions with full explanations, so you can judge the quality yourself.
Start 10 free questions