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:
- SQL Server on-premises
- Azure SQL services
You’re a database administrator who manages on-premises and cloud databases built with SQL Server and Azure SQL services.
As the Azure database administrator, you implement and manage the operational aspects of cloud-native and hybrid data platform solutions built on SQL Server and Azure SQL services. You use a variety of methods and tools to perform and automate day-to-day operations, including applying knowledge of using Transact-SQL (T-SQL) and other tools for administrative management purposes.
You’re responsible for the following concerning database solutions:
- Performance monitoring and optimization
You evaluate and implement migration strategies for moving databases between Azure and on-premises. Plus, you work with Azure data engineers, Azure solution architects, Azure developers, data scientists, and other professionals to manage operational aspects of data platform solutions.
As a candidate for this exam, you should have knowledge of and experience with:
- Azure SQL Database
- Azure SQL Managed Instance
- SQL Server on Azure Virtual Machines (Windows and Linux)
The English language version of this exam was updated on August 23, 2023. Review the study guide linked in the “Tip” box for details about the latest changes. If a localized version of this exam is available, it will be updated approximately eight weeks after this date. While Microsoft makes every effort to update localized versions as noted, there may be times when the localized versions of this exam are not updated on this schedule.
Passing score: 700. Learn more about exam scores.
Part of the requirements for: Microsoft Certified: Azure Database Administrator Associate
Related exams: noneGo to Learn Profile
- The English language version of this exam was updated on August 23, 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 (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%)
Two ways to prepare
As the Azure database administrator, you implement and manage the operational aspects of cloud-native and hybrid data platform solutions built on SQL Server and SQL database services.
Explore steps to get certified as an Azure Database Administrator Associate and the resources available to help you prepare.
Explore all certifications in a concise training and certifications guide.
Check out an overview of fundamentals, role-based and specialty certifications.
Boost your odds of success with this great offer.
Get help through Microsoft Certification support forums. A forum moderator will respond in one business day, Monday-Friday.
Review and manage your scheduled appointments, certificates, and transcripts.
Learn more about requesting an accommodation for your exam.
Review the exam policies and frequently asked questions.