Skip to main content
Ameerpet, Hyderabad · Classroom & live online
Cloud Soft Solutions

DP-300 Exam Guide 2026: Azure Database Administrator, Security, Query Store, HA/DR, 7-Week Plan and 15 Scenarios

DP-300 (Azure Database Administrator Associate): pass mark 700, skills updated 27 October 2026. Azure SQL deployment and migration, Always Encrypted, RLS and ledger, Query Store and DMVs, elastic jobs, failover groups and availability groups, a 7-week plan and 15 scenarios.

DP-300 Azure Database Administrator exam guide 2026, Cloud Soft Solutions
Last updated · 6 min read · 1,330 words

DP-300 Azure Database Administrator exam guide 2026, Cloud Soft Solutions

Exam DP-300: Administering Microsoft Azure SQL Solutions earns the Microsoft Certified: Azure Database Administrator Associate. It covers Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VMs and on-premises SQL Server: deployment and migration, security (Always Encrypted, TDE, row-level security, ledger), performance tuning with Query Store and DMVs, automation, and high availability with failover groups and Always On availability groups. The skills measured were last updated on 27 October 2026.

SQL Server DBAs are still in steady demand in Hyderabad's banking and GCC sector, and most of those roles now include Azure. This guide follows the official study guide: five skill areas with weights, the HA/DR options to tell apart, a 7-week plan and 15 original scenario questions.

Quick facts (Microsoft Learn, November 2026)

ItemDetail
CertificationMicrosoft Certified: Azure Database Administrator Associate
Passing score700
Skills measuredAs of 27 October 2026 (minor change to data-at-rest and in-transit security)
RenewalEvery year, with a free online assessment on Microsoft Learn
PracticePractice Assessment on AI Skills Navigator (and the legacy one on Learn)
PriceBased on the country where you take the exam (Pearson VUE)

Read the official DP-300 study guide before booking. New to Azure data? Start with DP-900.

Skills measured and weights

Skill areaWeight
Plan and implement data platform resources15–20%
Implement a secure environment20–25%
Monitor, configure and optimise database resources20–25%
Configure and manage automation of tasks15–20%
Plan and configure a high availability and disaster recovery (HA/DR) environment20–25%

1. Data platform resources (15–20%)

  • Choosing a database offering; automated deployment; Azure Arc-enabled SQL; Azure SQL Database in Microsoft Fabric; partitioning and sharding; hybrid deployments; patching IaaS.
  • Scale and performance for SQL Database, Managed Instance and SQL on VMs; partitioning; data compression.
  • Migration: online vs offline; migrating to and between Azure SQL services; Managed Instance database copy and move; troubleshooting.

2. Security (20–25%)

  • Authentication and authorisation: Microsoft Entra authentication; principals; users from Entra identities; least privilege; T-SQL permissions.
  • Data at rest and in transit: TDE; object-level encryption; server and database firewall rules; Always Encrypted (including secure enclaves); Private Link and service endpoints.
  • Compliance: data classification; audits; change tracking; dynamic data masking; ledger; row-level security.
FeatureWhat it protects against
TDESomeone stealing database or backup files
Always EncryptedAdmins and the database engine seeing sensitive column values
Dynamic data maskingCasual exposure in query results (not true encryption)
Row-level securityUsers reading rows that aren't theirs
LedgerUndetected tampering with data history

3. Monitor and optimise (20–25%)

  • Monitoring: performance baselines; metric sources; database watcher; Extended Events.
  • Query performance: Query Store; blocking; DMVs; index changes; query rewrites; execution plans; Intelligent Insights.
  • Configuration: index and statistics maintenance; DBCC CHECKDB; automatic tuning; server settings; Resource Governor; database-scoped configuration; scaling compute and storage; intelligent query processing.
-- Top 5 queries by average CPU from Query Store
SELECT TOP 5 q.query_id, qt.query_sql_text,
       AVG(rs.avg_cpu_time) AS avg_cpu_us, SUM(rs.count_executions) AS runs
FROM sys.query_store_query q
JOIN sys.query_store_query_text qt ON q.query_text_id = qt.query_text_id
JOIN sys.query_store_plan p ON p.query_id = q.query_id
JOIN sys.query_store_runtime_stats rs ON rs.plan_id = p.plan_id
GROUP BY q.query_id, qt.query_sql_text
ORDER BY avg_cpu_us DESC;

-- Who is blocking whom right now
SELECT session_id, blocking_session_id, wait_type, wait_time, command
FROM sys.dm_exec_requests WHERE blocking_session_id <> 0;

4. Automation (15–20%)

  • SQL Server Agent: maintenance schedules; alerts and notifications; troubleshooting jobs.
  • Deployment: ARM and Bicep templates; Azure PowerShell; Azure CLI.
  • Azure tasks: elastic jobs (Azure SQL Database has no SQL Agent); automation; alerts.

5. HA/DR (20–25%)

  • Strategy from RPO and RTO; hybrid HA/DR; Azure-specific options; testing.
  • Backups: native backup and restore; point-in-time restore; long-term retention; T-SQL backups; backup to cloud storage.
  • Configuring active geo-replication, Always On availability groups, failover groups, Failover Cluster Instances on Azure VMs and log shipping; monitoring and troubleshooting.
NeedUsual choice
Readable secondary in another region for one Azure SQL databaseActive geo-replication
Fail over a group of databases together with one connection endpointFailover groups (SQL Database or Managed Instance)
SQL Server on Azure VMs with database-level HAAlways On availability groups
Instance-level HA on VMs with shared storageAlways On Failover Cluster Instance
Restore to how the data looked 30 minutes agoPoint-in-time restore

7-week study plan

WeekFocusLab
1SQL Database vs Managed Instance vs SQL on VMs; purchasing models; deployment with BicepDeploy one of each with infrastructure as code
2Migration: online vs offline, Azure Database Migration Service, MI copy and moveMigrate AdventureWorks to Azure SQL
3Entra authentication, permissions, firewalls, Private LinkContained Entra users with least privilege
4TDE, Always Encrypted, masking, RLS, auditing, ledger, classificationEncrypt a PAN column with Always Encrypted
5Query Store, DMVs, blocking, indexes, statistics, automatic tuning, IQPFind and fix a slow query with Query Store
6SQL Agent, elastic jobs, PowerShell and CLI automationNightly index maintenance as an elastic job
7Backups, PITR, LTR, geo-replication, failover groups, AGs; Practice AssessmentFailover group drill; book the exam

15 scenario questions with answers

These are original scenarios written for this guide, not exam questions.

1. An app needs SQL Agent, cross-database queries and CLR with minimal changes in a managed service. Which offering?
Azure SQL Managed Instance.

2. You need full OS access and a specific SQL Server feature not in PaaS. Which offering?
SQL Server on an Azure VM.

3. On-premises SQL Servers should be managed and governed from Azure. What do you use?
Azure Arc-enabled SQL Server.

4. A 2 TB database must migrate with only minutes of downtime. Online or offline?
An online migration with continuous sync, then a short cutover.

5. DBAs must never see customers' Aadhaar numbers, even with sysadmin rights. Which feature?
Always Encrypted.

6. Support staff should see only the last four digits of phone numbers. Which feature?
Dynamic data masking.

7. Each branch manager may query only their branch's rows. Which feature?
Row-level security.

8. Auditors need proof that financial records weren't altered. Which feature?
Ledger tables.

9. A query became slow after a plan change last night. Where do you compare plans and force the old one?
Query Store.

10. Users report hangs; one session holds locks others wait on. What do you check?
Blocking in sys.dm_exec_requests (blocking_session_id) and the head blocker's query.

11. Index maintenance must run nightly across 40 Azure SQL databases. What do you use?
Elastic jobs.

12. Backups must be kept for 7 years for regulation. Which feature?
Long-term backup retention.

13. A developer deleted rows 20 minutes ago. How do you recover?
Point-in-time restore to a new database just before the delete, then copy the rows back.

14. Several databases must fail over to another region together without changing the connection string. What do you configure?
A failover group with its listener endpoint.

15. The business allows 5 seconds of data loss and 1 hour of downtime. What do these numbers describe?
RPO (5 seconds) and RTO (1 hour).

After DP-300

Cloud Soft Solutions in Ameerpet, Hyderabad teaches SQL Server, Azure SQL, data engineering and Azure administration with real-time projects. See the APEX program and all courses.

📞 Call +91 96660 19191 · WhatsApp · Flat No. 513, 5th Floor, Nilagiri Block, Aditya Enclave, Ameerpet, Hyderabad

Frequently Asked Questions

What certification does DP-300 earn?
Microsoft Certified: Azure Database Administrator Associate.

What is the DP-300 passing score?
700.

When were the DP-300 skills last updated?
The current skills measured apply as of 27 October 2026.

Which DP-300 areas have the most weight?
Security, monitoring and optimisation, and HA/DR, each at 20–25%.

Does DP-300 cover on-premises SQL Server?
Yes. It covers Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VMs and on-premises SQL Server, including hybrid deployments.

How often must DP-300 be renewed?
Every year, with a free online renewal assessment on Microsoft Learn.

Share𝕏inf✉
EnrollWhatsAppCall us