Microsoft Certified:

Azure Database Administrator Associate

Objetivos

El administrador de la base de datos de Azure implementa y administra los aspectos operativos de las soluciones de plataforma de datos híbridas y nativas de la nube basadas en los servicios de datos de Microsoft Azure y Microsoft SQL Server. El administrador de la base de datos de Azure usa una variedad de métodos y herramientas para realizar las operaciones diarias, incluida la aplicación de conocimientos sobre el uso de T-SQL para fines de administración administrativa.

Nota: Este curso no está disponible aún. Fecha de salida estimada: julio de 2020. Esta información no es definitiva y puede haber cambios menores una vez que se lance la certificación.
Note: This course is not yet available. Expected date: July 2020. This information is not final and minor changes may occur once certification is released.

Exámenes requeridos: DP-300

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 andOptimize Operational Resources
Monitor activity and performance
Implement performance-related maintenance tasks
Identify performance-related issues
Configure a user database for optimal performance

Optimize Query Performance
Review query plans
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
Configure DR by using platform and database tools

 

Perform Administration by Using T-SQL
Examine system health
Monitor database configuration by using T-SQL
Manage authentication by using T-SQL

Gadesoft Madrid

C/Clara del rey, 14
28002 Madrid, Spain
Tfno: 91 510 23 90
 info@gadesoft.com

Gadesoft Barcelona

Carrers del Madrazo, 27 - 2º 4ª
08006 Barcelona
Tfno: 93 368 0087