Study Guide · DP-300

Administering Microsoft Azure SQL Solutions Study Guide

5 domains · 15 subtopics · weighted by the official DP-300 exam guide

Exam DP-300: Administering Microsoft Azure SQL Solutions is for "a database administrator who manages cloud and on-premises databases built with Azure SQL services and SQL Server," in Microsoft's DP-300 audience profile. The profile lists four responsibilities, "Management", "Availability", "Security", and "Performance monitoring and optimization", and adds: "You evaluate and implement migration strategies for moving databases between Azure and on-premises."

The skills measured open with "Recommend a database offering based on specific requirements", and the offerings differ in control: Azure SQL Database supports most on-premises database-level capabilities, Azure SQL Managed Instance almost all on-premises instance-level and database-level capabilities, and SQL Server on Azure Virtual Machines offers full administrative control over the SQL Server instance and underlying OS. Another bullet reads "Recommend HA/DR strategy based on Recovery Point Objective/Recovery Time Objective (RPO/RTO) requirements", where the RPO is the maximum duration of acceptable data loss, and the RTO the maximum duration of acceptable downtime.

The skills measured as of October 27, 2026 cover five domains: Plan and implement data platform resources (15–20%), Implement a secure environment (20–25%), Monitor, configure, and optimize database resources (20–25%), Configure and manage automation of tasks (15–20%), and Plan and configure a high availability and disaster recovery (HA/DR) environment (20–25%). Their fifteen skills, three per domain, include "Implement security for data at rest and data in transit", "Monitor and optimize query performance", "Create and manage SQL Server Agent jobs", and "Configure HA/DR for database solutions".