DP-300 Plan and implement data platform resources Practice Question
Which THREE factors should you consider when choosing between Azure SQL Database and Azure SQL Managed Instance for a new workload?
⚠ Common exam trap
Many exam-takers assume static IP addresses are a key differentiator, but Azure SQL Managed Instance does not provide a static public IP by default, and both services can use Private Link for stable private IPs, making this a red herring.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Lift-and-shift migration of on-premises databases
Azure SQL Managed Instance is designed for lift-and-shift migrations of on-premises databases, offering near 100% compatibility with SQL Server features like instance-level configurations, linked servers, and SQL Server Agent. Azure SQL Database, as a Platform-as-a-Service (PaaS) offering, lacks these instance-scoped capabilities, making Managed Instance the preferred choice for migrating existing databases with minimal changes.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Need for a static IP address
Why it's wrong here
Managed Instance has a fixed public endpoint, but single database does not.
- ✓
Lift-and-shift migration of on-premises databases
Why this is correct
Managed Instance offers higher compatibility for existing databases.
- ✓
Requirement for cross-database queries
Why this is correct
Managed Instance supports cross-database queries; single database does not.
- ✗
Both support automated backups
Why it's wrong here
Both support automated backups, so it's not a differentiating factor.
- ✓
Use of SQL Server Agent jobs
Why this is correct
SQL Agent is available in Managed Instance but not in single database.
Go deeper
Related to this question
Learn chapter
Overview of Azure Data Platform Options
Key term
Azure SQL Managed Instance
Azure SQL Managed Instance is a fully managed cloud database service that gives you nearly all the features of Microsoft SQL Server on your own server, without you having to manage the hardware or operating system.
Key term
Azure SQL Performance Tuning
Azure SQL Performance Tuning is the process of optimizing the speed and efficiency of queries and database operations in Microsoft Azure SQL Database or SQL Managed Instance to reduce latency and improve throughput.
About these practice questions
This DP-300 question is part of Courseiva's 906-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-300 exam.