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

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.

    €695.00