Exam DP-300: Administering Microsoft Azure SQL Solutions

Candidates for this exam should have subject matter expertise in building database solutions that are designed to support multiple workloads built with Azure SQL database services.

Candidates for this exam are database administrators who manage on-premises and cloud databases built with SQL Server and SQL database services. The Azure database administrator implements and manages the operational aspects of cloud-native and hybrid data platform solutions built on SQL Server and SQL database services. Professionals in this role use a variety of methods and tools to perform and automate day-to-day operations, including applying knowledge of using T-SQL for administrative management purposes. These professionals are responsible for management, availability, security, and performance monitoring and optimization of database solutions. They evaluate and implement migration strategies for moving databases to Azure. Plus, they work with Azure data engineers, Azure solution architects, Azure developers, and other professionals to manage operational aspects of data platform solutions.

Candidates for this exam should have knowledge of and experience with Azure SQL Edge, Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines (Windows and Linux). The Azure database administrator implements and manages the operational aspects of cloud-native and hybrid data platform solutions built with Microsoft SQL Server and Microsoft Azure Data Services. The Azure database administrator uses a variety of methods and tools to perform day-to-day operations, including applying knowledge of using T-SQL for administrative management purposes.

Plan and implement data platform resources (20—25%)

Implement a secure environment (15—20%)

Monitor, configure, and optimize database resources (20—25%)

Configure and manage automation of tasks (15—20%)

Plan and configure a high availability and disaster recovery (HA/DR) environment (20—25%)