Practice Test

DP 300

Administering Microsoft Azure SQL Solutions

Description

This exam measures your ability to accomplish the following technical tasks: plan and implement data platform resources; implement a secure environment; monitor, configure, and optimize database resources; configure and manage automation of tasks; and plan and configure a high availability and disaster recovery (HA/DR) environment.<br><br> As a candidate for this exam, you should have subject matter expertise in building database solutions that are designed to support multiple workloads built with: SQL Server on-premises, Azure SQL services and You’re a database administrator who manages on-premises and cloud databases built with SQL Server and Azure SQL services.<br><br> As the Azure database administrator, you implement and manage the operational aspects of cloud-native and hybrid data platform solutions built on SQL Server and Azure SQL services. You use a variety of methods and tools to perform and automate day-to-day operations, including applying knowledge of using Transact-SQL (T-SQL) and other tools for administrative management purposes.<br><br> You’re responsible for the following concerning database solutions: Management, Availability, Security and Performance monitoring and optimization. You evaluate and implement migration strategies for moving databases between Azure and on-premises. Plus, you work with Azure data engineers, Azure solution architects, Azure developers, data scientists, and other professionals to manage operational aspects of data platform solutions.<br><br> As a candidate for this exam, you should have knowledge of and experience with: Azure SQL Database, Azure SQL Managed Instance and SQL Server on Azure Virtual Machines (Windows and Linux)<br><br>

Adaptive Test Technology

We use our proprietary Adaptive Test Tech™ which adapts the questioning sequence and complexity based on the success of the questions attempted.

45

Questions

90 min

Duration

215

Question pool

Skills measured

  • Plan and implement data platform resources 25%
  • Implement a secure environment 20%
  • Monitor, configure, and optimize database resources 25%
  • Configure and manage automation of tasks 20%
  • Plan and configure a high availability and disaster recovery (HA/DR) environment 25%

DP 300 certification links