Microsoft Certified: Azure Database Administrator Associate

The Azure Database Administrator implements and manages the operational aspects of cloud-native and hybrid data platform solutions built on Microsoft Azure data services and Microsoft SQL Server. 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.

Skills measured

Exam DP-300: Administering Relational Databases on Microsoft Azure (beta)

The following course prepare the exam DP-300:  

Course DP-300: Administering Relational Databases on Microsoft Azure (beta)* 

Contenidos

Plan and Implement Data Platform Resources

• Deploy resources by using manual methods
• Recommend an appropriate database offering based on specific requirements
• Configure resources for scale and performance
• Evaluate a strategy for moving to Azure
• Implement a migration or upgrade strategy for moving to Azure

Implement a Secure Environment

• Configure database authentication by using platform and database tools
• Configure database authorization by using platform and database tools
• Implement security for data at rest
• Implement security for data in transit
• Implement compliance controls for sensitive data

Monitor and Optimize Operational

• Resources Monitor activity and performance
• Implement performance-related maintenance tasks
• Identify performance-related issues
• Configure resources for optimal performance
• Configure a user database for optimal performance

Optimize Query Performance

• Review query plans
• Evaluate performance improvements
• Review database table and index design

Perform Automation of Tasks

• Create scheduled tasks
• Evaluate and implement an alert and notification strategy
• Manage and automate tasks in Azure

Plan and Implement a High Availability and Disaster Recovery (HADR) Environment

• Recommend an HADR strategy for a data platform solution
• Test an HADR strategy by using platform, OS and database tools
• Perform backup and restore a database by using database tools
• Configure DR by using platform and database tools
• Configure HA using platform, OS and database tools

Perform Administration by Using T-SQL

• Examine system health
• Monitor database configuration by using T-SQL
• Perform backup and restore a database by using T-SQL
• Manage authentication by using T-SQL
• Manage authorization by using T-SQL

*Debido a que este curso y examen están en beta, Microsoft nos informa que puede producirse cualquier cambio en la información facilitada sin previo aviso.