Microsoft Certified: Azure Database Administrator Associate Questions and Answers
200 questions organized by topic with detailed explanations
Microsoft
DP-300
200 questions
5 topics
Updated May 2026Plan and implement data platform resources
36 questions10 easy20 medium6 hard~17% of exam
A single Azure SQL Database is expected to grow far beyond traditional size limits and needs support for named replicas ...A company wants to move an existing SQL Server instance to Azure with minimal to no compatibility issues. Which target p...An administrator moves a database to another Azure SQL Managed Instance by using the managed instance move feature. What...
Implement a secure environment
43 questions12 easy22 medium9 hard~22% of exam
Monitor, configure, and optimize database resources
44 questions12 easy20 medium12 hard~22% of exam
Configure and manage automation of tasks
34 questions7 easy17 medium10 hard~17% of exam
A DBA creates an elastic job schedule with a start time in the past and later enables the job. What should the DBA expec...Which Azure SQL feature lets you schedule Transact-SQL jobs across one or many Azure SQL databases?A job target group in elastic jobs includes an Azure SQL logical server. What happens at runtime?
Plan and configure a high availability and disaster recovery (HA/DR) environment
43 questions11 easy21 medium11 hard~22% of exam
What is the best practice for selecting regions for Azure SQL failover groups?A failover group is being created between two Azure SQL Managed Instances. Why must the instances share the same DNS zon...An application must protect a specific committed transaction from being lost during a later geo-failover. What should th...
All Questions
| # | Question | Topic | Difficulty |
|---|---|---|---|
| 1 | A single Azure SQL Database is expected to grow far beyond traditional size limits and needs support... | Plan and implement data platform resources | medium |
| 2 | Which monitoring technology is the lightweight replacement for SQL Trace and SQL Server Profiler? | Monitor, configure, and optimize database resources | easy |
| 3 | A DBA wants to integrate Intelligent Insights with centralized monitoring. Which destinations are su... | Monitor, configure, and optimize database resources | medium |
| 4 | What does transparent data encryption protect in Azure SQL? | Implement a secure environment | easy |
| 5 | A company wants to move an existing SQL Server instance to Azure with minimal to no compatibility is... | Plan and implement data platform resources | easy |
Sign in to see all 200 questions
Create a free account to browse all questions — completely free during our launch phase.
Ready to test your knowledge?
Take a full Microsoft Certified: Azure Database Administrator Associate practice test with timed exam simulation.
Start Practice Test