Exam DP-300: Administering Relational Databases on Microsoft Azure
Documentation
HomepageOverview
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
-
Exam DP-300: Skills Outline
Learning Paths
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
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
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
Learn how to deploy, secure, monitor and troubleshoot Azure SQL database.
Levels: Beginner
Roles: Database Administrator, Administrator, Solutions Architect
Modules
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
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
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