Administering Microsoft Azure SQL Solutions

Microsoft Certified: Administering Microsoft Azure SQL Solutions - DP-300

160 Real Exam Questions / 3 Tests

This exam measures your ability to accomplish the following technical tasks: plan and implement data platform resources; implement a secure environment; monitor, configure, and optimize database resources; configure and manage automation of tasks; and plan and configure a high availability and disaster recovery (HA/DR) environment.

Skills measured

• The English language version of this exam was updated on February 2, 2023. Review the study guide linked in the preceding “Tip” box for details about the skills measured and latest changes.

• Plan and implement data platform resources.

• Implement a secure environment.

• Monitor, configure, and optimize database resources.

• Configure and manage automation of tasks.

• Plan and configure a high availability and disaster recovery (HA/DR) environment.

Candidates for this exam should have subject matter expertise in building database solutions that are designed to support multiple workloads built with SQL Server on-premises and 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 and other tools 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 between Azure and on-premises. Plus, they work with Azure data engineers, Azure solution architects, Azure developers, data scientists, 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).