DP-300 Certification Practice Question #41

Question

You have a Microsoft SQL Server 2017 server.

You need to migrate the server to Azure. The solution must meet the following requirements:

•	Ensure that the latest version of SQL Server is used.
•	Support the SQL Server Agent service.
•	Minimize administrative effort.

What should you use?

Accepted Answer

Azure SQL Managed Instance is the only PaaS option that supports SQL Server Agent, always runs the latest SQL Server version, and minimizes administrative effort (no OS/patching/VM management). SQL on VM satisfies Agent and latest version but has significantly more admin overhead. Azure SQL Database (single or elastic) does not support SQL Server Agent at all. With 14 votes and the Suggested Answer all pointing to D, and MS Learn confirming Agent support on MI, D is clearly correct.

More DP-300 practice questions