MCDBA

The Microsoft Certified Database Administrator (MCDBA) certification provides proof of your ability to design, implement and manage SQL Server 2000 databases. Although this certification was retired on 30 September 2012, if you achieved the MCDBA certification before that date, it will still appear on your transcript as a legacy certification.

Since the course has been expired, you can take up a similar course from various learning platforms. For a similar course like MCDBA, you can consider the Microsoft Certified Azure Database Administrator Associate (MCADAA) certificate that also 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 course prepares you to perform day-to-day operations by applying knowledge of T-SQL and using a variety of methods and tools.

MCDBA Certification Exams 

MCDBA candidates are required to pass the following four exams to achieve the certification. This includes three core exams and one elective exam. For the core section, candidates are required to pass one SQL Server administration exam, one SQL Server design exam and a Windows 2000 Server exam to fulfil the networking systems core requirements. While the elective exam provides proof of expertise with a specific Microsoft server product.

Core Exams (3 Exams Required)

Elective Exams (1 Exam Required)

MCADAA Certification Exam

The above-mentioned exams are for MCDBA certification, however, if you are thinking to go for MCADAA certification since MCDBA is no longer exist then you need to pass Exam DP-300: Administering Relational Databases on Microsoft Azure. This exam will test your ability to accomplish the following tasks:

• Plan and implement data platform resources
• Implement a secure environment
• Monitor and optimize operational resources
• Optimize query performance
• Perform automation of tasks
• Plan and implement a High Availability and Disaster Recovery (HADR) environment and
• Perform administration by using T-SQL

MCDBA Job Profiles 

Job opportunities for those who obtain Microsoft Certified Data Base Administrator Certification or Microsoft Certified Azure Database Administrator Associate (MCADAA) vary but could include those working in areas of networking, systems engineering, systems analysis, technical consulting or IT management. According to the BLS, most of these positions require that one holds at least a bachelor's degree in the appropriate area.

Frequently Asked Questions (FAQs)

Q. What is MCDBA certification?

Q. How can I pursue MCDBA certification?

Q. How is MCDBA or MCADAA certification beneficial?

Q. Can I take MCDBA or MCADAA certification online?

Q. What exams are required to earn MCADAA certification?