Practice
Learn at your own pace. Answer questions one at a time with instant feedback and explanations.
Start practiceAdministering Microsoft Azure SQL Solutions
DP-300 validates the skills of an Azure database administrator who implements and manages the operational aspects of cloud-native and hybrid data platform solutions built on Azure SQL services and SQL Server. It covers deployment, security, performance optimization, task automation, and high availability/disaster recovery. Passing this exam earns the Microsoft Certified: Azure Database Administrator Associate certification.
Mock exam
Simulate the real thing. Take a timed, full-length test and review your score and weak areas.
Sign up to startStudy your way: beyond Practice and Mock exam, choose adaptive, hard mode, ready review, objective coverage, or retry-your-misses — and set your own question count, timer, and pass mark.
About this exam
Exam DP-300 measures your ability to administer Azure SQL services and SQL Server: planning and deploying data platform resources, implementing a secure environment, monitoring and optimizing database resources, automating tasks, and configuring high availability and disaster recovery. The skills measured reflect the outline updated April 24, 2026.
Who should take this exam
Database administrators who manage cloud and on-premises databases built with Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure Virtual Machines, and SQL Server on-premises, and who automate day-to-day operations using T-SQL and other tools.
Career benefits
Earning the Azure Database Administrator Associate certification demonstrates expertise in managing the operational aspects of Azure SQL and hybrid data platforms, supporting roles such as database administrator, data platform engineer, and cloud database specialist.
How to prepare
Gain hands-on experience with Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure VMs. Practice T-SQL administration, security configuration, performance monitoring with Query Store and DMVs, automation with SQL Server Agent and elastic jobs, and HA/DR with availability groups, failover groups, and geo-replication. Use Microsoft Learn paths and the official study guide.
Quick facts
Exam cost$165 USD
Valid forOne year (renew free on Microsoft Learn)
Length120 minutes
Questions on exam50
Passing score700 / 1000
FormatMultiple choice, multiple response, drag-and-drop ordering, case studies, and scenario items.
Practice questions150
Objectives5
Official pageView
What's covered
1. Plan and implement data platform resources
15–20%- 1a Plan and deploy Azure SQL solutions
- 1b Configure resources for scale and performance
- 1c Plan and implement a migration strategy
2. Implement a secure environment
20–25%- 2a Configure database authentication and authorization
- 2b Implement security for data at rest and data in transit
- 2c Implement compliance controls for sensitive data
3. Monitor, configure, and optimize database resources
20–25%- 3a Monitor resource activity and performance
- 3b Monitor and optimize query performance
- 3c Configure database solutions for optimal performance
4. Configure and manage automation of tasks
15–20%- 4a Create and manage SQL Server Agent jobs
- 4b Automate deployment of database resources
- 4c Create and manage database tasks in Azure
5. Plan and configure a high availability and disaster recovery (HA/DR) environment
20–25%- 5a Plan an HA/DR strategy for database solutions
- 5b Plan and perform backup and restore of a database
- 5c Configure HA/DR for database solutions
Frequently asked questions
Are these real exam questions?
No. These are original practice questions written to match the exam objectives, each with an explanation so you actually learn the material — not exam dumps.
How does practice mode work?
You answer questions one at a time with instant feedback and explanations. Over time the app adapts, prioritizing the objectives and questions you struggle with most.
What is a mock exam?
A timed, full-length simulation that holds feedback until the end, then shows your score, pass/fail result, and a breakdown by objective.
Can I customize how I study?
Yes. Pick the study mode that fits — adaptive practice, hard mode, ready-for-review, objective coverage, or retrying questions you've missed — and set your own question count, timer, and passing score for each session.
Do I need an account?
You can try free questions for this exam without signing in. Create a free account to save your progress, track weak objectives, and unlock the full question bank.