Azure DP-300 case studies
Azure DP-300 · Put your knowledge to work in context.
The Microsoft Certified: Azure Database Administrator Associate credential is an intermediate-level, role-based certification for database administrators who manage cloud, on-premises, and hybrid relational database infrastructure. Microsoft positions it for professionals who implement and manage the operational aspects of data platform solutions built on Azure SQL services and SQL Server, covering management, availability, security, and performance monitoring and optimization, along with evaluating migration strategies between Azure and on-premises. The Azure DP-300 case studies are 5 cases and about 3,616 words.
1Migrating 90 tenant databases off SQL Server VMs
A logistics ISV runs 90 tenant databases on six SQL Server 2019 VMs. Three VMs are close to full on a 2 TB data drive.
732 words, about 4 min2Private connectivity and Entra identity for a bank's database estate
A bank has one Azure SQL Database (General Purpose, 8 vCores) for a customer portal and one SQL Managed Instance for a legacy lending system, both in West Europe. Group policy requires that no database be reachable from the internet.
697 words, about 3 min3Diagnosing a daily CPU spike on Business Critical
An Azure SQL Database (Business Critical, 16 vCores) hosts an order-management API. Between 09:00 and 10:00 every weekday CPU reaches 96-100% for about 40 minutes and P95 request latency rises from 80 ms to 4.5 seconds.
709 words, about 4 min4Replacing manual DBA scripts across 220 databases
A retailer runs 220 databases on 18 logical servers plus 3 managed instances. Each night, DBAs open SSMS and run index rebuild and UPDATE STATISTICS scripts per database; it takes about 4 hours and often overruns the 06:00 batch window.
710 words, about 4 min5RPO and RTO tiers for an insurer's claims platform
An insurer runs a claims portal on Azure SQL Database, General Purpose, 12 vCores, in West Europe, about 1.4 TB. The business accepts an RPO of 15 minutes and an RTO of 4 hours for the portal generally.
768 words, about 4 min