Exam DP-300: Administering Relational Databases on Microsoft Azure

Documentation

Homepage

Overview

Overview

Candidates for this exam are database administrators and data management specialists that manage on-premises and cloud relational databases built on top of Microsoft SQL Server and Microsoft Azure data services.

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.

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

Skills Measured

  • Plan and implement data platform resources (15-20%)
  • Implement a secure environment (15-20%)
  • Monitor and optimize operational resources (15-20%)
  • Optimize query performance (5-10%)
  • Perform automation of tasks (10-15%)
  • Plan and implement a High Availability and Disaster Recovery (HADR) environment (15-20%)
  • Perform administration by using T-SQL (10-15%)

Getting Started

Getting Started

  1. 6/23/2020, Trainings
    Exam DP-300: Skills Outline

Learning Paths

Implement a secure environment for a database service
Published: 8/2/2020, Length: 1:52:00

Implement SQL Server-based options for authentication and authorization, as well as Azure options for securing Azure SQL databases. Explore encryption, firewalls and advanced threat protection.

Levels: Intermediate

Roles: Data Analyst, Data Engineer, Database Administrator

Modules

Monitor and optimize operational resources in SQL Server
Published: 8/3/2020, Length: 2:40:00

Configure hardware and server resources for optimum performance after establishing a baseline. Identify sources of performance problems. Troubleshoot using Azure SQL Intelligent Insights.

Levels: Intermediate

Roles: Administrator

Modules

Automate tasks in SQL Server
Published: 8/23/2020, Length: 1:47:00

Scripting repetitive tasks in Azure SQL for regular maintenance jobs and multi-instance administration. Automation of error and resource alerts. Configuration of notifications for failures.

Levels: Intermediate

Roles: Data Analyst, Data Engineer, Database Administrator

Modules

Azure SQL fundamentals
Published: 8/5/2020, Length: 7:14:00
Plan and implement data platform resources
Published: 9/25/2020, Length: 2:11:00

Deploy data platform resources in Azure for SQL Server and Open Source databases. Explore options for upgrade and migration. Calculate resource requirements and create templates.

Levels: Intermediate

Roles: Data Engineer, Database Administrator

Modules

Optimize query performance in SQL Server
Published: 8/23/2020, Length: 2:14:00

Analyze individual query performance and determine where improvements can be made. Explore performance-related Dynamic Management Objects. Investigate how indexes and database design affect queries.

Levels: Intermediate

Roles: Data Analyst, Data Engineer, Database Administrator, Developer

Modules

Plan and implement a high availability and disaster recovery environment
Published: 9/11/2020, Length: 2:13:00

Data must be available when needed. Configure, test and manage a solution for high availability and disaster recovery using Azure tools and SQL Server tools.

Levels: Intermediate

Roles: Data Analyst, Data Engineer, Database Administrator

Modules