Exam DP-300: Administering Microsoft Azure SQL Solutions
Proctored Microsoft certification exam focused on administering Azure SQL and hybrid SQL Server database environments.
- Type
- Written
- Duration
- 100 min
Exam sections
Plan and implement data platform resources
Design and deploy Azure SQL solutions by recommending appropriate offerings and automation methods. This includes identifying use cases for Azure Arc-enabled SQL, designing table partitioning or sharding, and managing compute and storage resources for optimal scalability and performance.
Question notes
Weight: 15-20%. Covers planning offerings, automated deployments, scaling, and migration strategies.
Preparation tips
Practice provisioning Azure SQL Database and Managed Instance, and familiarize yourself with migration assessment tools.
Implement a secure environment
Configure robust security through Microsoft Entra ID authentication and granular authorization. Implementation includes data encryption at rest and in transit using TDE and Always Encrypted, alongside compliance controls like auditing, classification, and row-level security.
Question notes
Weight: 20-25%. Covers Entra ID authentication, TDE, Always Encrypted, firewall rules, and compliance controls.
Preparation tips
Focus on Microsoft Entra ID integration and T-SQL commands for managing security principals and permissions.
Monitor, configure, and optimize database resources
Establish performance baselines and monitor activity using metrics and Extended Events. Optimization involves tuning query performance with Query Store and DMVs, reviewing execution plans, and applying database-scoped configurations or Intelligent Query Processing features.
Question notes
Weight: 20-25%. Covers performance baselines, Query Store, DMVs, Intelligent Query Processing, and index maintenance.
Preparation tips
Use DMVs and Query Store to troubleshoot performance issues and practice reviewing execution plans for slow queries.
Configure and manage automation of tasks
Automate database administration tasks by creating SQL Server Agent jobs and scheduling alerts. This section also covers deploying resources via ARM templates, Bicep, PowerShell, and Azure CLI, as well as managing elastic jobs and automation tasks within the Azure ecosystem.
Question notes
Weight: 15-20%. Covers SQL Server Agent jobs, ARM/Bicep templates, PowerShell, CLI, and Azure elastic jobs.
Preparation tips
Familiarize yourself with Bicep and PowerShell for Azure resource deployment and explore Azure Automation tasks.
Plan and configure a high availability & disaster recovery (HA/DR) environment
Develop HA/DR strategies aligned with RPO and RTO targets. Tasks include executing backup and restore operations, managing long-term retention, and configuring solutions like active geo-replication, failover groups, and Always On availability groups for Azure SQL services.
Question notes
Weight: 20-25%. Covers RPO/RTO planning, backup/restore, geo-replication, failover groups, and availability groups.
Preparation tips
Practice setting up a failover group and testing point-in-time restores in an Azure environment.
