Practice Exams | Microsoft Azure DP-300 Database Admin

Be prepared for the Microsoft Azure Exam DP-300: Administering Relational Databases on Microsoft Azure

Created by: Wade Henderson
Sr IT Project Manager

What Will I Learn?

• Exam DP-300: Administering Relational Databases on Microsoft Azure
• 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 and Optimize Operational Resources
• Monitor activity and performance
• Implement performance-related maintenance tasks
• Identify performance-related issues
• Configure resources for optimal performance
• Configure a user database for optimal performance
• Optimize Query Performance
• Review query plans
• Evaluate performance improvements
• 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
• Perform backup and restore a database by using database tools
• Configure HA/DR by using OS, platform, and database tools
• Perform Administration by Using T-SQL
• Examine system health
• Monitor database configuration by using T-SQL
• Perform backup and restore a database by using T-SQL
• Manage authentication by using T-SQL
• Manage authorization by using T-SQL

Requirements

• Candidates for this exam are database administrators and data management specialists that manage on-premises and cloud relational databases built with 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 Azure Data Services and 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.

Target audience

• Microsoft Azure professionals who want to be Microsoft DP-300 certified