Azure Mastery
Download
Azure Mastery
Microsoft Certification DP-300
On-device AI scores your readiness, builds an adaptive study plan, and flags topics fading from memory — before they cost you the exam.
Get exam-ready for DP-300 (Microsoft Azure Database Administrator) on iPhone or iPad. Azure Mastery uses on-device AI to predict your readiness score across all five DP-300 domains, build a personalised study plan from your weak spots, and surface topics you're forgetting — all without sending a single byte off your device.
The exam
DP-300 is the Microsoft Certified: Azure Database Administrator Associate exam — the credential hiring managers expect when posting "Database Administrator", "Azure SQL DBA", or "Cloud Database Engineer" roles on the Microsoft data platform. It's the natural next step after DP-900 for anyone whose day job has shifted from generalist data work into running and securing SQL workloads in production. DP-300 is the only Microsoft Associate cert dedicated to operating the SQL family on Azure.
DP-300 is hands-on and operational. It validates that you can plan and implement Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure VMs; secure data with Microsoft Entra authentication, Always Encrypted, dynamic data masking, row-level security, TDE, and Microsoft Defender for SQL; tune workloads via Query Store, automatic tuning, indexes, partitioning, and Resource Governor; automate operations with SQL Agent, elastic jobs, PowerShell, and ARM/Bicep; and design HA/DR with Always On availability groups, geo-replication, auto-failover groups, and PITR. Expect scenario questions that show you a query plan, a config snippet, or a recovery requirement and ask what you'd do.
Microsoft updated the DP-300 skills outline on 24 April 2026. Every question in Azure Mastery's DP-300 bank is mapped to the current outline — no leftover questions on retired services. Read the official outline at learn.microsoft.com.
Skills measured · April 2026
Five domains, with weights set by Microsoft's April 2026 update. Every domain summary below is paraphrased from the official skills outline; bullet-level objectives in Azure Mastery are tagged so you always know which domain you're being tested on and where your weak spots cluster.
The deployment foundation. Choose between Azure SQL Database (single, elastic pool, hyperscale), Azure SQL Managed Instance, and SQL Server on Azure VMs. Plan for compute and storage requirements, deployment via portal/PowerShell/CLI/Bicep, scaling and elastic pools. Plus migration paths via Azure Database Migration Service and Azure Migrate, including online vs offline approaches. Around 6–12 questions per sitting.
The compliance and access surface. Microsoft Entra and SQL authentication, contained users, RBAC and role mappings, server roles, database roles. Encryption — Transparent Data Encryption (TDE), Always Encrypted, dynamic data masking, row-level security. Auditing, threat detection via Microsoft Defender for SQL, network restrictions (firewall rules, virtual network rules, Private Link). Around 8–15 questions.
The performance angle. Query Store for query and plan history, automatic tuning, manual index tuning (clustered, non-clustered, columnstore, filtered, included columns), statistics, partitioning, In-Memory OLTP, Resource Governor, query plan analysis. Dynamic management views (DMVs), Intelligent Insights, Performance Monitor, blocking and deadlock troubleshooting. Around 8–15 questions.
The DBA-as-code layer. SQL Server Agent jobs (steps, schedules, alerts, operators) on Managed Instance and SQL VM. Elastic jobs on Azure SQL Database. PowerShell, Azure CLI, Logic Apps, and Azure Automation runbooks for routine maintenance. ARM/Bicep templates for repeatable deployment. Alerts via Azure Monitor and Action Groups. Around 6–12 questions.
The resilience story. Always On availability groups on SQL VM (synchronous vs asynchronous, read-only routing, listener configuration), failover cluster instances. For Azure SQL Database and Managed Instance: active geo-replication, auto-failover groups, business-critical and zone-redundant tiers. Backup strategies — point-in-time restore, long-term retention, geo-restore, RPO/RTO planning. Around 8–15 questions.
Designed for DP-300
Azure Mastery ships with 350 DP-300 practice questions, every one written specifically against the current (April 2026) skills outline — not generic database trivia. Each question carries a domain tag mapped to the official five domains (platform resources, secure environment, monitor/optimize, automation, HA/DR), so you always know which area you're being tested on and where your weak spots are clustered. T-SQL query snippets, configuration JSON, and HA/DR scenario setups appear throughout — matching the format of the live exam.
The on-device Exam IQ engine predicts your DP-300 score before you sit the exam. After roughly 30 questions it has enough signal to give a confidence-scored prediction (e.g. "708 ±60, 68% confidence") — and tells you the specific topics that are dragging your readiness down. No vague "study more" advice; just a ranked list of objectives where improvement would move your score the furthest.
The adaptive study plan rebuilds itself from your answer history. Get an Always Encrypted vs TDE scenario wrong? You'll see another encryption-choice question in the next session. Master "active geo-replication vs auto-failover groups" three sessions running and the engine backs off, surfacing fresh Query Store or Resource Governor scenarios. The plan optimises for the gap between where you are and the 700 pass score, not for blind volume.
Knowledge decay tracking matters more for DP-300 than for foundational exams — five domains is a lot to retain, and the topic you mastered three weeks into your study window is the topic you'll forget by exam day if you stop revising. Azure Mastery tracks every topic's decay curve and flags topics approaching expiry. The padlock icon on the Today screen is your "revisit before you forget" cue, and weak-spot drills automatically pull from decayed topics first.
Real exam simulation mode runs at DP-300's actual length and time pressure: a randomised 40–60-question set drawn from the full 350-question bank, weighted by domain percentages from the April 2026 outline, with the 100-minute timer running and no jumping back to flag-and-review. It's the closest you can get to the live Pearson VUE / online-proctored experience without sitting the exam.
Everything runs on-device. Your answer history, your readiness gauge, your decay alerts — none of it leaves your iPhone or iPad. No account required to start, no tracking, no sync server. Privacy-first by design.
6-week study plan
Most candidates pass DP-300 after four to eight weeks of focused study, depending on prior Azure experience. The six-week plan below maps onto the five DP-300 domains, Azure Mastery's adaptive sessions, and the in-app exam simulator. Adjust pace to taste — the readiness gauge tells you when you're done, not the calendar.
Inside the app
DP-300's question bank uses the same formats Microsoft puts on the live exam — not just multiple choice. Each visualisation below is a faithful mock of how the type renders inside Azure Mastery on iPhone and iPad. Exam-simulator mode runs all of them at full 100-minute length with no flag-and-review jumps, mirroring Pearson VUE.
One correct answer from four to six options. The most common type on every Azure exam — practical recall of services, settings, and limits.
~50% of questionsPick two or more correct answers from a list. Microsoft tells you exactly how many to choose. Partial credit not awarded — you need every selection right.
All-or-nothingArrange items into the correct sequence — deployment steps, the order operations occur in a pipeline, troubleshooting flows. Long-press to drag on touch.
Order mattersTap the correct area of an image — the right setting in a portal screenshot, the right resource in a topology diagram. Practical visual recall under time pressure.
Tap targetA multi-paragraph scenario followed by 4–6 linked questions. Common on DP-300 in the storage and identity domains; dominant on AZ-305 and AZ-400.
Multi-questionAn Azure Mastery exclusive. When you answer incorrectly, an on-device Apple Foundation Model writes a targeted explanation grounded in the correct rationale. Never leaves your device.
App exclusiveFrequently asked
The DP-300 voucher is USD $165 in the United States. Pricing varies by region — in the UK it's typically around £128. Microsoft sometimes runs free-voucher promotions during events such as Microsoft Build or Microsoft Ignite, so check your Microsoft Learn profile for any active offers before booking. DP-300 also requires annual renewal (free, online), so factor that into long-term cost planning.
Yes. Microsoft Associate certifications including DP-300 expire annually. Renewal is free — a 25–30 question online assessment on Microsoft Learn within the six-month window before your expiration date. The renewal targets recent skills outline updates, so staying current is straightforward if you remain broadly active in the role. (Fundamentals certifications such as AZ-900 are different — those don't expire.)
The first retake is allowed after 24 hours. Second and third retakes each require a 14-day wait. Microsoft caps retakes at five attempts per 12-month rolling period. Each attempt requires a new voucher purchase.
Most candidates pass DP-300 after four to eight weeks of focused study, assuming some prior IT or cloud experience. If Azure is genuinely new to you, plan for two to three months — the exam expects you to know specific PowerShell and Azure CLI commands, not just describe concepts. Azure Mastery's readiness gauge tells you when you're at exam-ready; don't book until it shows roughly 720 or higher with reasonable confidence.
DP-900 first if databases aren't already your day job. DP-900 (Microsoft Azure Data Fundamentals) teaches the data vocabulary — relational vs non-relational, OLTP vs OLAP, the SQL-family service triangle, Cosmos DB API options — without expecting T-SQL. DP-300 is the role-based Associate exam: it expects you to manage Azure SQL workloads in production. Most candidates pass DP-900 in a few weeks, then spend two to three months on DP-300.
Yes, very different. DP-300 is the Database Administrator Associate cert — running and securing SQL workloads (Azure SQL Database, Managed Instance, SQL on VM) including HA/DR, performance tuning, and automation. DP-100 is the Data Scientist Associate cert — building, training, deploying, and optimising ML models on Azure Machine Learning. Different parts of the data stack: DP-300 is operations, DP-100 is modelling. Pick based on role.
Where DP-300 fits
DP-300 is the Azure Database Administrator Associate cert. It pairs with DP-900 as the recommended fundamentals, and is the only Microsoft Associate cert dedicated to operating the SQL family on Azure. Tap any linked exam below to see its dedicated study app page.
Download Azure Mastery free. 350 DP-300 practice questions across all five domains, AI score prediction, full-length exam simulator, adaptive study plan. iPhone & iPad.
Download Azure Mastery — free iPhone & iPad · Free to start · No account required