DP-300Administering Microsoft Azure SQL Solutions
What the exam covers
- Plan and implement data platform resources 33 practice questions 15–20%
- Implement a secure environment 19 practice questions 20–25%
- Monitor, configure and optimize database resources 18 practice questions 20–25%
- Configure and manage automation of tasks 12 practice questions 15–20%
- Plan and configure a high availability and disaster recovery environment 18 practice questions 20–25%
Study guide
From Microsoft
About DP-300
Running SQL on Azure: choosing between SQL Database, Managed Instance and SQL Server on VMs, migrating, securing with Entra authentication and encryption, tuning performance, automating jobs, and designing for high availability and disaster recovery.
Who it's for. Database administrators moving SQL Server workloads to Azure.
How to prepare
- Know the HADR options per platform: failover groups, geo-replication, Always On availability groups.
- TDE, Always Encrypted and dynamic data masking each protect against a different threat.
- Query Store and automatic tuning are the go-to answers for performance regressions.
Sample DP-300 questions
Try these with the answers on the page, then practise the full bank.
- A multi-tenant analytics vendor keeps one database per client. Usage across clients is sporadic and peaks land at unrelated hours. The vendor wants to keep strict data separation and control spend. Which approach fits best? Plan and implement data platform resources
- A healthcare company stores full and differential .bak files from its SQL Server estate in a blob container. It wants to restore those backup files into a managed platform with the fewest format changes. Which target supports this? Plan and implement data platform resources
- Before moving a heavily loaded SQL Server to Azure, a consultant wants the Azure SQL migration tooling to gather live workload counters and suggest which Azure SQL service tier and compute size would fit. Which feature provides this? Plan and implement data platform resources
- A regulated customer requires that all connections to its Azure SQL logical server use at least TLS 1.2, and that older protocol versions be rejected. Which server setting should the administrator configure? Implement a secure environment
- After a statistics update, a critical reporting query suddenly runs ten times slower. Query Store shows that the query switched to a new plan with much higher duration. The DBA needs to restore the earlier performance immediately while investigating the root cause. What should the DBA do? Monitor, configure and optimize database resources
- A SaaS company wants Azure to recommend and create missing indexes automatically on its production database, but it does not want the platform to remove any existing index without review. Which automatic tuning configuration meets this requirement? Monitor, configure and optimize database resources
- A DBA reviews a clustered index that is 45 percent fragmented, with many partially filled pages after heavy updates. The database is in production and the index must remain available during maintenance. What is the most appropriate action? Monitor, configure and optimize database resources
- During a bulk-load job, log_write_percent stays near 100 percent for long periods while CPU stays around 30 percent. The loader commits each row individually. The team wants the load to finish faster without changing the data. Which change is most effective? Monitor, configure and optimize database resources
- All 14 sample questions
Questions people ask
Is this DP-300 practice exam free?
Yes. All 100 questions, the timed mock exam and the explanations are free, and there's no account to create.
Are these real exam questions?
No. Real exam questions are confidential under the Azure candidate agreement. These are practice questions written to cover the same domains in the same scenario style, each with an explanation of why the answer is right.
How is the DP-300 mock exam scored?
Questions are drawn from every domain in proportion to the exam guide, and you get a raw percentage with a breakdown by domain. Azure uses scaled scoring, so treat 75% or more here as a sign you're ready rather than a predicted score.
Where is my progress saved?
In your browser, on this device. Nothing is sent to us apart from the answers you check, and clearing site data resets it.