Azure•Associate•DP-300

Microsoft Certified: Azure Database Administrator Associate

Administer SQL Server database infrastructure for cloud, on-premises, and hybrid relational databases using Microsoft Azure data services. Manage operational aspects of cloud-native and hybrid database solutions built on Azure SQL services.

Note: This syllabus summary was last updated in November 2025. For the most current and detailed syllabus information, please visit the official certification provider's website.

Exam Summary

TIME

100

Minutes

TOTAL

Questions

PRICE

$165

USD

VALID

Years

PASS

700

/1000

Prerequisites (Optional)

Recommended experience before taking this exam

Knowledge of Azure SQL Database, SQL Managed Instance, SQL on VMs
Experience with T-SQL
Understanding of database administration

Exam Domains & Topics

Domain 1

20%

Plan and Implement Data Platform Resources

Plan and deploy Azure SQL Database

Plan and deploy Azure SQL Managed Instance

Plan and deploy SQL Server on Azure Virtual Machines

Configure database resources for performance and scale

Implement hybrid environments

Configure high availability solutions

Plan for disaster recovery

Domain 2

20%

Implement a Secure Environment

Configure database authentication and authorization

Configure security for data at rest and in transit

Implement database auditing and threat detection

Implement data masking and encryption

Configure Azure SQL firewall and virtual network rules

Implement Microsoft Entra authentication

Configure transparent data encryption (TDE)

Domain 3

25%

Monitor, Configure, and Optimize Database Resources

Monitor resource activity and performance

Configure and optimize database resources

Configure database for optimal performance

Analyze and optimize queries

Configure automatic tuning

Implement indexing strategies

Configure Query Store

Troubleshoot performance issues

Domain 4

15%

Configure and Manage Automation of Tasks

Create and manage SQL Agent jobs

Automate deployment using ARM templates and Azure CLI

Implement Azure Automation

Configure elastic jobs

Implement policy-based management

Configure maintenance tasks

Domain 5

20%

Plan and Configure High Availability and Disaster Recovery (HA/DR) Environment

Implement backup and restore strategies

Implement Always On availability groups

Configure active geo-replication

Implement failover strategies

Configure Azure Site Recovery

Test disaster recovery procedures

Implement point-in-time restore

Configure long-term retention

Azure•Associate•DP-300

Microsoft Certified: Azure Database Administrator Associate

Note: This syllabus summary was last updated in November 2025. For the most current and detailed syllabus information, please visit the official certification provider's website.

Exam Summary

TIME

100

Minutes

TOTAL

Questions

PRICE

$165

USD

VALID

Years

PASS

700

/1000

Prerequisites (Optional)

Recommended experience before taking this exam

Knowledge of Azure SQL Database, SQL Managed Instance, SQL on VMs
Experience with T-SQL
Understanding of database administration

Exam Domains & Topics

Domain 1

20%

Plan and Implement Data Platform Resources

Plan and deploy Azure SQL Database

Plan and deploy Azure SQL Managed Instance

Plan and deploy SQL Server on Azure Virtual Machines

Configure database resources for performance and scale

Implement hybrid environments

Configure high availability solutions

Plan for disaster recovery

Domain 2

20%

Implement a Secure Environment

Configure database authentication and authorization

Configure security for data at rest and in transit

Implement database auditing and threat detection

Implement data masking and encryption

Configure Azure SQL firewall and virtual network rules

Implement Microsoft Entra authentication

Configure transparent data encryption (TDE)

Domain 3

25%

Monitor, Configure, and Optimize Database Resources

Monitor resource activity and performance

Configure and optimize database resources

Configure database for optimal performance

Analyze and optimize queries

Configure automatic tuning

Implement indexing strategies

Configure Query Store

Troubleshoot performance issues

Domain 4

15%

Configure and Manage Automation of Tasks

Create and manage SQL Agent jobs

Automate deployment using ARM templates and Azure CLI

Implement Azure Automation

Configure elastic jobs

Implement policy-based management

Configure maintenance tasks

Domain 5

20%

Plan and Configure High Availability and Disaster Recovery (HA/DR) Environment

Implement backup and restore strategies

Implement Always On availability groups

Configure active geo-replication

Implement failover strategies

Configure Azure Site Recovery

Test disaster recovery procedures

Implement point-in-time restore

Configure long-term retention

Microsoft Certified: Azure Database Administrator Associate

Exam Summary

Prerequisites (Optional)

Exam Domains & Topics

Plan and Implement Data Platform Resources

Implement a Secure Environment

Monitor, Configure, and Optimize Database Resources

Configure and Manage Automation of Tasks

Plan and Configure High Availability and Disaster Recovery (HA/DR) Environment

Cloud Practice Test

Microsoft Certified: Azure Database Administrator Associate

Exam Summary

Prerequisites (Optional)

Exam Domains & Topics

Plan and Implement Data Platform Resources

Implement a Secure Environment

Monitor, Configure, and Optimize Database Resources

Configure and Manage Automation of Tasks

Plan and Configure High Availability and Disaster Recovery (HA/DR) Environment