DP-300: Administering Relational Databases on Microsoft Azure (beta)
nanforiberica
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
- 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
- Perform administration by using T-SQL
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.