MICROSOFTMicrosoft Certified:Azure Database Administrator Associate
The Microsoft Certified: Azure Database Administrator Associate certification validates your ability to manage and secure SQL Server databases on Azure and on-premises. It is designed for database administrators who implement and manage operational aspects of cloud-native and hybrid data platform solutions. Earning it demonstrates your expertise in managing availability, security, and performance of database solutions.
481 practice questions · Updated 2026-07-30
5Domains
15Objectives
124Concepts
481Questions
DP-300 Curriculum
Every domain, objective, and concept the DP-300 exam measures.
- Database Offering Recommendation
- Automated Deployment Methods
- Azure Arc-Enabled SQL Use Cases
- Azure SQL Database in Microsoft Fabric
- Table Partitioning Planning
- Database Sharding Solutions
- Deploying Database Offerings
- Hybrid SQL Server Deployment
- Patching and Updating IaaS Deployments
- Azure SQL Database Scaling
- Azure SQL Database Performance Tuning
- Azure SQL Managed Instance Scaling
- Azure SQL Managed Instance Performance Optimization
- SQL Server VM Scaling
- SQL Server VM Performance Tuning
- Table Partitioning Configuration
- Data Compression Techniques
- Migration Requirements Evaluation
- Offline Migration Strategy Evaluation
- Online Migration Strategy Evaluation
- Online Migration Implementation
- Offline Migration Implementation
- Azure Migration Implementation
- Azure SQL Services Migration
- Azure SQL Managed Instance Database Copy
- Migration Troubleshooting
- Microsoft Entra ID Authentication
- SQL VM Authentication
- Security Principals
- Create Users from Entra Identities
- Graphical Tools Permissions
- Principle of Least Privilege
- Troubleshoot Auth Issues
- T-SQL Authentication Management
- Transparent Data Encryption (TDE) Basics
- Implementing TDE
- Object-Level Encryption
- Firewall Rules Configuration
- Always Encrypted Fundamentals
- Implementing Always Encrypted
- Always Encrypted with VBS Enclaves
- Private Links Configuration
- Service Endpoints Configuration
- Data Classification Strategy
- Server Audits Configuration
- Database Audits Configuration
- Change Data Tracking Implementation
- Dynamic Data Masking Implementation
- Ledger Implementation in Azure SQL
- Row-Level Security Implementation
- Operational Performance Baseline
- Performance Metric Sources
- Performance Metric Interpretation
- Activity and Performance Configuration
- Database Watcher Monitoring
- Extended Events Monitoring
- Query Store Configuration
- Query Store Monitoring
- Session Blocking Identification
- Session Blocking Resolution
- Performance Issues with DMVs
- Index Change Identification
- Index Implementation
- Query Construct Recommendations
- Execution Plan Review
- Intelligent Insights Monitoring
- Index Maintenance
- Statistics Maintenance
- Database Integrity Checks
- Database Automatic Tuning
- Server Performance Settings
- Resource Governor Configuration
- Database-Scoped Configuration
- Compute and Storage Scaling
- Intelligent Query Processing Use Cases
- SQL Server Agent Overview
- Create SQL Server Agent Jobs
- Manage Job Schedules
- Configure Job Steps
- Set Up Job Alerts
- Configure Notifications
- Monitor Job Execution
- Troubleshoot Job Failures
- Review Job History
- ARM Template Basics
- Bicep Language Fundamentals
- Deploying with ARM Templates
- Deploying with Bicep
- Azure PowerShell Deployment
- Azure CLI Deployment
- Deployment Monitoring
- Troubleshooting Deployments
- Elastic Jobs Overview
- Create Elastic Jobs
- Configure Elastic Jobs
- Azure Automation Overview
- Create Database Tasks with Automation
- Configure Database Task Automation
- Alerts and Notifications Overview
- Configure Task Alerts
- Configure Task Notifications
- Troubleshoot Automated Tasks
- RPO and RTO Definitions
- HA/DR Strategy Recommendation
- Hybrid Deployment HA/DR Evaluation
- Azure HA/DR Solutions
- HA/DR Testing Procedure Planning
- Database Backup Strategy
- Database Restore Strategy
- Native Tools Backup
- Native Tools Restore
- Point-in-Time Restore
- Long-Term Backup Retention
- T-SQL Backup
- T-SQL Restore
- Cloud Storage Backup
- Cloud Storage Restore
- Active Geo-Replication Configuration
- Always On Availability Groups Setup
- Failover Groups Configuration
- Always On Failover Cluster Instances Setup
- Log Shipping Configuration
- HA/DR Solution Monitoring
- HA/DR Solution Troubleshooting
Ready to practice?Test your knowledge with exam-style questions or take an intelligent quiz tailored to your level.
Percentages reflect share of the current practice bank, not official exam weightings — no structured per-skill weight is published for DP-300, so none is invented.