DP-300: Administering Relational Databases on Microsoft Azure

Log in to Enroll

Summary

  • intermediate
  • azure-database-mysql
  • azure-database-postgresql
  • sql-server
  • azure
  • azure-sql-database
  • azure-storage
  • azure-automation
  • azure-virtual-machines
  • 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.Note: This beta exam will not be available until April 2, 2020. This information is not final and there may be minor changes once the beta exam is released.

Learning paths

2 hr 11 min
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.

Modules in this learning path

  • Deploy SQL Server in a virtual machine
    9 Units
    1 hr 0 min

    Configure virtual machine sizing, storage, and networking options to ensure adequate performance for your database workloads. Choose and configure appropriate high availability options. Investigate options for migrating existing workloads.

  • Deploy MariaDB, MySQL, and PostgreSQL on Azure
    7 Units
    23 min

    Compare Open Source Azure Database offerings with Azure SQL Server offerings. Configure an Open Source database and configure high availability and security options.

  • Deploy Azure SQL Database
    7 Units
    48 min

    Provision and deploy Azure SQL Database and SQL Server Managed Instances. Select the appropriate options when performing a migration to the SQL PaaS platform.

2 hr 14 min
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.

Modules in this learning path

  • Explore performance-based design
    7 Units
    50 min

    Evaluate possible changes to indexes. Determine the impact of changes to queries and indexes. Explore relevant Dynamic Management Objects.

  • Evaluate performance improvements
    7 Units
    30 min

    Evaluate possible changes to indexes. Determine the impact of changes to queries and indexes. Explore relevant Dynamic Management Objects.

  • Describe SQL Server query plans
    6 Units
    54 min

    Read and understand various forms of execution plans. Compare estimated vs actual plans. Learn how and why plans are generated.

2 hr 13 min
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.

Modules in this learning path

  • Describe high availability and disaster recovery strategies
    9 Units
    59 min

    Plan appropriate HA/DR strategy based on RTO and RPO. Choose best solution for IaaS or PaaS deployments or hybrid workloads.

  • Explore IaaS and PaaS platform tools for high availability and disaster recovery
    8 Units
    43 min

    Deploy Windows Server Failover Cluster and AGs in Azure and hybrid environments. Configure temporal tables, geo-replication and auto failover groups.

  • Back up and restore databases
    6 Units
    31 min

    Plan and implement policy for recovering data in case of user error or failure of technology. Explore various options for how and where to backup and restore databases.

1 hr 52 min
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.

Modules in this learning path

  • Configure database authentication and authorization
    10 Units
    49 min

    Contrast authentication using Azure Active Directory vs Windows Active Directory vs SQL Server authentication. Implement various security principals and configure permissions.

  • Implement compliance controls for sensitive data
    6 Units
    20 min

    Explore data classification capabilities and degrees of confidentiality. Explore and configure advanced threat protection options, including SQL Injection.

  • Protect data in-transit and at rest
    8 Units
    43 min

    Protect data in-transit and at rest

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

Modules in this learning path

  • Explore causes of performance issues
    6 Units
    36 min

    Explore the Query Store for tracking down problematic queries. Understand how SQL Server and Azure SQL manage currency by locking and blocking, or by using snapshots. Implement fragmentation checks and defragmentation.

  • Describe performance-related maintenance tasks in SQL Server
    6 Units
    23 min

    Implement tasks for both IaaS and PaaS to maintain indexes, and statistics. Explore the automatic tuning features of Azure SQL Database.

  • Configure SQL Server resources for optimal performance
    7 Units
    35 min

    Choose the appropriate size and storage options for your Azure SQL databases. Configure server resources such as tempdb. Understand the usage of Resource Governor.

  • Configure databases for performance
    6 Units
    24 min

    Control database-level configuration options. Explore Intelligent Query Processing. Configure Open Source databases for optimum performance.

  • Describe performance monitoring
    7 Units
    42 min

    Compare Azure and on-premises tools for monitoring and measuring performance. Determine critical metrics. Understand the purpose of a baseline for comparative analysis.

1 hr 47 min
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.

Modules in this learning path

  • Configure automatic deployment for Azure SQL Database
    6 Units
    27 min

    Utilize Azure Resource Manager templates for deploying Azure SQL resources.

  • Schedule tasks using SQL Server Agent
    7 Units
    46 min

    Explore SQL automation for scheduled tasks and automatic alerts for SQL Server and Managed Instance. Configure extended event sessions for tracing activities.

  • Manage Azure PaaS resources using automated methods
    8 Units
    34 min

    Explore SQL automation for Azure SQL Database and Open Source databases. Configure elastic jobs and Azure Policy.

7 hr 14 min
Learn how to deploy, secure, monitor and troubleshoot Azure SQL database.

Modules in this learning path

  • Deliver consistent performance with Azure SQL
    10 Units
    1 hr 24 min

    Deliver consistent performance with Azure SQL

  • Introduction to Azure SQL
    6 Units
    44 min

    This module introduces Azure SQL. Learn about various deployment options and service tiers and what to use for your organization.

  • Deploy highly available solutions by using Azure SQL
    11 Units
    1 hr 34 min

    In this module, you’ll learn how to deploy highly available solutions by using Azure SQL. You’ll also look at architectures and how they affect availability.

  • Secure your data with Azure SQL
    10 Units
    1 hr 24 min

    Secure your data with Azure SQL

  • Deploy and configure servers, instances, and databases for Azure SQL
    9 Units
    1 hr 14 min

    Deploy and configure servers, instances, and databases for Azure SQL

  • Putting it all together with Azure SQL
    7 Units
    54 min

    Putting it all together with Azure SQL