Question 1
A team is building a new cloud-born order management application. It needs a single relational database, built-in backups and patching, and no instance-level features such as SQL Agent or cross-database queries. Which Azure SQL deployment option is the best fit?
Correct Answer:
Azure SQL Database single database
Question 2
An existing line-of-business application uses SQL Agent jobs and cross-database queries. The company wants a PaaS target with minimal code changes. Which option should you recommend?
Correct Answer:
Azure SQL Managed Instance
Question 3
A security tool must be installed on the database host, and the DBA must control the Windows operating system and SQL Server service configuration. Which deployment option meets these requirements?
Correct Answer:
SQL Server on Azure Virtual Machines
Question 4
A migrated application heavily uses three-part naming between user databases and the team wants to avoid rewriting that logic. Which Azure SQL target is most appropriate?
Correct Answer:
Azure SQL Managed Instance
Question 5
A SaaS platform provisions one database per customer. Most tenant databases are idle most of the day, but their activity spikes at different times. Which deployment model is usually the most cost-effective?
Correct Answer:
An Azure SQL Database elastic pool
Question 1
Exam overview

About this Exam

Prepare with the Azure DP-300 Practice Questions - Microsoft Certified Azure Database Administrator Associate (DP-300) Exam practice quiz. This question bank includes 100 questions covering database, azure, wants, server, and service. Use it to review important concepts, identify knowledge gaps, and build confidence for the related exam, course, or assessment.

More details

Additional Information

Azure DP-300 Practice Questions - Microsoft Certified Azure Database Administrator Associate (DP-300) Exam

This practice set contains 100 questions from the matching question bank and focuses on database, azure, wants, server, and service. Work through each question carefully, review the provided solutions, and revisit topics that need more study before your next attempt.

This is an independent study resource intended for practice and review; it is not an official examination or an endorsement by any organization named in the title.

Quiz information

Frequently Asked Questions

The complete question count is available after full access is unlocked.
No fixed duration is currently configured for this quiz.
Question explanations are included where they are available in the quiz content, helping you review the reasoning after answering.
Yes. You can retake the practice test again as you continue studying during your available access period.
After your access is confirmed, you can continue into the complete practice exam from this quiz flow.
Unless explicitly stated otherwise, this page provides independent practice material for study and exam preparation and is not the official examination itself.
Keep studying

Related Questions