Microsoft Azure Database Administrator - DP-300 Practice Exam
Validates skills in implementing and managing database solutions, security, performance, and availability
Same conditions as the real exam
65 questions, 120 minutes, no pausing.
Time limit
2h
Questions
65
Passing score
70%
Difficulty
Advanced
Category
Microsoft Azure Database Administrator
Sample questions
A few questions from this practice exam, with the correct answer and why it is correct.
1.A company must migrate a SQL Server database that uses SQL Server Agent jobs, cross-database queries, and CLR assemblies, with minimal code change. Which Azure SQL offering fits best?
- AAzure Synapse Analytics dedicated SQL pool
- BAzure SQL Database single database
- CAzure SQL Managed InstanceCorrect answer
- DAzure Database for PostgreSQL
Why
Azure SQL Managed Instance targets near-complete SQL Server engine compatibility, including SQL Server Agent, cross-database queries, and CLR. Azure SQL Database lacks instance-level features such as Agent.
2.Which Azure SQL deployment option gives the database administrator full control over the operating system and the SQL Server instance configuration?
- AAzure SQL Database
- BSQL Server on an Azure virtual machineCorrect answer
- CAzure SQL Managed Instance
- DAzure SQL Database serverless
Why
SQL Server on an Azure virtual machine is infrastructure as a service, so the customer controls the guest operating system, the instance settings, and patching.
3.What does the database compatibility level control in Azure SQL Database?
- AThe number of vCores allocated to the database
- BThe maximum size the database may reach
- CWhich query optimizer behaviours and T-SQL semantics applyCorrect answer
- DThe geo-replication topology of the database
Why
Compatibility level governs which query optimizer behaviours and Transact-SQL semantics apply, which lets a migrated database keep the behaviour of an older SQL Server version.
4.Which Azure SQL Database purchasing model expresses capacity as a blended measure of compute, memory, and IO?
- AThe vCore purchasing model
- BThe Hyperscale service tier
- CThe serverless compute tier
- DThe DTU purchasing modelCorrect answer
Why
The DTU model bundles compute, memory, and IO into a single unit. The vCore model exposes them separately, which allows independent sizing and Azure Hybrid Benefit.
5.Which Azure SQL Database service tier is designed for databases that must grow beyond 100 TB with rapid scaling and fast restores?
- AGeneral Purpose
- BBasic
- CBusiness Critical
- DHyperscaleCorrect answer
Why
Hyperscale separates compute from a distributed storage layer with page servers, which allows very large databases, near-instant backups, and rapid scale-out of read replicas.
Practice all 65 questions
Frequently asked questions
Is the Microsoft Azure Database Administrator - DP-300 practice exam free?
Yes. Every practice exam on NaHero is free and unlimited, whatever its level. You only need a free account to start. A premium plan adds the explanation behind each answer, your attempt history and your performance dashboard.
How many questions does it have and how long does it take?
65 questions with a 120-minute time limit, so you practise under the same time pressure as the real exam.
What score do I need to pass?
You need 70% to pass this practice exam. Your score and a per-question review are shown as soon as you finish.
Do I need an account?
Yes, a free account. It is what lets us save your attempt, score it and keep your history.
Can I retake it?
As many times as you like — attempts are unlimited and free. Questions are shuffled on every attempt.
Are these the real questions from the official exam?
No. NaHero does not reproduce questions from the official exam. These are practice questions written to match its format, topics and difficulty.