The exam
DP-300 validates the skills of an Azure database administrator who plans, implements, secures, monitors, optimizes, automates, and protects Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure Virtual Machines, and SQL Server on-premises. Covers platform deployment and migration, authentication and data protection, performance monitoring and tuning, task automation, and high availability/disaster recovery design.
Who it is for
As a candidate for this exam, you should have subject matter expertise in building database solutions that are designed to support multiple workloads built with Azure SQL services and SQL Server on-premises. You're a database administrator who manages cloud and on-premises databases built with Azure SQL services and SQL Server. As the Azure database administrator, you implement and manage the operational aspects of cloud-native and hybrid data platform solutions built on Azure SQL services and SQL Server, using methods and tools including Transact-SQL (T-SQL), to automate day-to-day operations. You're responsible for the management, availability, security, and performance monitoring and optimization of database solutions, and you evaluate and implement migration strategies for moving databases between Azure and on-premises. You work with Azure data engineers, Azure solution architects, Azure developers, data scientists, and other professionals to manage operational aspects of data platform solutions. You should have knowledge of and experience with Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure Virtual Machines (Windows and Linux), and SQL Server on-premises.
What it covers
Your readiness map in the app is organised the same way, so what you see here is exactly what you study against.
What Preppio gives you
Across every domain above, in 5 formats: concept, scenario, ordering, multi-select, matching. Each one explains why the right answer is right and every distractor wrong.
Per domain, whether you are ready, weak, or not started — the same domains and weights as the exam itself.
Your study partner. He tracks where you are weak and drills exactly that, instead of serving you what you already know.
Try one
Answer on the page. The explanation appears when you submit; use Next to move through the formats.
Sample 1 · Concept
You are using SQL Server Management Studio to configure permissions on an Azure SQL Database. You need to grant a reporting user named Report1 the ability to execute all stored procedures in the Sales schema, without granting SELECT access to the underlying tables directly. What should you do in the Properties dialog for the Sales schema?
Pick one, then submit.
Study links
FAQ
50 questions in 100 minutes.
70%, a scaled score of 700.
5 domains, weighted as the exam weights them: Plan and implement data platform resources (17%), Implement a secure environment (22%), Monitor, configure, and optimize database resources (22%), Configure and manage automation of tasks (17%) and Plan and configure a high availability and disaster recovery (HA/DR) environment (22%). Your readiness map in the app is organised by the same domains, so what you study against is what the exam tests.
Five formats: concept, scenario, ordering, multi-select and matching. The practice questions use every one of them, and the sample on this page shows one of each.
DP-300 is on the Single, Dual and All Access plans. You start on the free tier and add it from the plan picker inside the app. Three fundamentals exams (AZ-900, CLF-C02 and CDL) are always free, and the sample on this page is free to try.
Every question is generated from the exam's published objectives, then checked for accuracy, answer key and explanation before it is served. Nothing is copied from any exam, questions rotate by how often they have been seen, and they are retired when the objectives change.
