Essentials of Azure Database Administrator Associate Certification

The Azure Database Administrator Associate implements and manages the operational aspects of cloud-native and hybrid data platform solutions based on Microsoft Azure Data Services and Microsoft SQL Server. The Azure Database Administrator Associate uses a variety of approaches and technologies, including T-SQL abilities for administrative management, to carry out day-to-day activities.

To become an Azure Database Administrator Associate, you must successfully complete exam DP-300: Administering Relational Databases on Microsoft Azure.

Microsoft has designed the exam DP-300: Administering Relational Databases on Microsoft Azure to help you prepare for the test, which you can take even if you don't plan on being certified.

Taking exams is optional and exam fees are not included in the course price.

Target Group for Azure Database Administrator Associate Certification

Candidates for this exam are database administrators and data management specialists who manage on-premises and cloud-related databases based on Microsoft SQL Server and Microsoft Azure data services.

The Azure Database Administrator Associate implements and manages the operational aspects of cloud-native and hybrid data platform solutions based on Microsoft Azure Data Services and Microsoft SQL Server. Microsoft Azure Data Services and Microsoft SQL Server are used to create hybrid data platform solutions.

This role is responsible for the administration, availability, security and performance monitoring, and optimization of modern relational database solutions. This role works in tandem with the Azure Data Engineer role to manage operational aspects of data platform solutions.

 Requirements for the Training

Azure principles as presented in the Microsoft Azure Fundamentals exam AZ-900.

Training Content

To prepare for the DP-300 Azure Database Administrator Associate certification exam, Microsoft has developed the DP-300 exam.

The Azure Database Administrator Associate role:

• Azure data platform roles
• Azure database platforms and options
• SQL Server Compatibility Levels
• Azure preview features

Planning and implementation of data platform resources:

• Deploying SQL Server using IaaS
• Deploying SQL Server using PaaS
• Deploying open-source database solutions on Azure

Implementing a secure environment:

• Database authentication configuration
• Database authorization configuration
• Implementation of security for data at rest
• Implementing security for data in transit
• Implementation of compliance controls for sensitive data

Monitoring and optimization of resources:

• Baselines and performance monitoring
• Main causes of performance problems
• Configuration of resources for optimal performance
• user database configuration
• Performance-related maintenance tasks

Query Performance Optimization:

• SQL Server query plans
• Performance-based database design
• Evaluation of performance improvements

Automation of tasks:

• Set up automatic provisioning
• Define scheduled tasks
• Configuration of extended events

Management of Azure PaaS resources using automated methods

• High-availability and disaster-recovery environment planning and implementation:
• High availability and disaster recovery strategies
• IaaS platform and database tools for HADR
• PaaS platform and database tools for HADR
• Database backup and recovery

The Azure Database Administrator Associate is responsible for the implementation and management of cloud-native and hybrid data platform solutions created using Microsoft SQL Server and Microsoft Azure Data Services. To accomplish day-to-day operations, the Azure Database Administrator Associate uses a range of methodologies and tools, including T-SQL skills for administrative management.

Profile of the Candidates

The target audience for this exam is data professionals who manage data and databases and want to understand how to operate Microsoft Azure's data platform technologies. This exam is also beneficial for data architects and application developers who need to know what technologies are available for the Azure data platform and how to use them through applications.

Successful Azure Database Administrator Associate has prior database management experience as well as technical knowledge of cloud technologies.

Specifically:

Working with, maintaining, and improving SQL Server Knowledge of Azure, including resource deployment and management