
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)
| Item | Detail |
|---|---|
| Certification | Microsoft Certified: Azure Database Administrator Associate |
| Passing score | 700 |
| Skills measured | As of 27 October 2026 (minor change to data-at-rest and in-transit security) |
| Renewal | Every year, with a free online assessment on Microsoft Learn |
| Practice | Practice Assessment on AI Skills Navigator (and the legacy one on Learn) |
| Price | Based 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 area | Weight |
|---|---|
| Plan and implement data platform resources | 15–20% |
| Implement a secure environment | 20–25% |
| Monitor, configure and optimise database resources | 20–25% |
| Configure and manage automation of tasks | 15–20% |
| Plan and configure a high availability and disaster recovery (HA/DR) environment | 20–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.
| Feature | What it protects against |
|---|---|
| TDE | Someone stealing database or backup files |
| Always Encrypted | Admins and the database engine seeing sensitive column values |
| Dynamic data masking | Casual exposure in query results (not true encryption) |
| Row-level security | Users reading rows that aren't theirs |
| Ledger | Undetected 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.
| Need | Usual choice |
|---|---|
| Readable secondary in another region for one Azure SQL database | Active geo-replication |
| Fail over a group of databases together with one connection endpoint | Failover groups (SQL Database or Managed Instance) |
| SQL Server on Azure VMs with database-level HA | Always On availability groups |
| Instance-level HA on VMs with shared storage | Always On Failover Cluster Instance |
| Restore to how the data looked 30 minutes ago | Point-in-time restore |
7-week study plan
| Week | Focus | Lab |
|---|---|---|
| 1 | SQL Database vs Managed Instance vs SQL on VMs; purchasing models; deployment with Bicep | Deploy one of each with infrastructure as code |
| 2 | Migration: online vs offline, Azure Database Migration Service, MI copy and move | Migrate AdventureWorks to Azure SQL |
| 3 | Entra authentication, permissions, firewalls, Private Link | Contained Entra users with least privilege |
| 4 | TDE, Always Encrypted, masking, RLS, auditing, ledger, classification | Encrypt a PAN column with Always Encrypted |
| 5 | Query Store, DMVs, blocking, indexes, statistics, automatic tuning, IQP | Find and fix a slow query with Query Store |
| 6 | SQL Agent, elastic jobs, PowerShell and CLI automation | Nightly index maintenance as an elastic job |
| 7 | Backups, PITR, LTR, geo-replication, failover groups, AGs; Practice Assessment | Failover 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
- Practise SQL interview questions and go further with DP-700 or AZ-305.
- Compare with the Google Cloud Database Engineer guide.
- See live database and cloud jobs.
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.



