Exam DP-300 topic 1 question 52 discussion

Common solution from all 3 requirements is Azure SQL Managed Instance. Ensure that the latest version of SQL Server is used - Possible solutions - both MI and Azure SQL DB • Support the SQL Server Agent service - Possible solutions - both MI and VM • Minimize administrative effort - Possible solutions - both MI and Azure SQL DB

SO if everyone is saying D, then what's the actual correct answer then?

Answer is C ( Chat GPT) To migrate your Microsoft SQL Server 2017 server to Azure while meeting the specified requirements, including ensuring the latest version of SQL Server is used, supporting the SQL Server Agent service, and minimizing administrative effort, you should use: C. SQL Server on Azure Virtual Machines Explanation: SQL Server on Azure Virtual Machines allows you to run SQL Server in a virtualized environment hosted in Azure, providing full control over the SQL Server instance, including the ability to install and manage SQL Server Agent service. With SQL Server on Azure Virtual Machines, you can choose the SQL Server version you want to deploy, ensuring that the latest version is used. This option provides the closest compatibility to an on-premises SQL Server environment while minimizing administrative effort compared to other options like managing individual databases in Azure SQL Database or Azure SQL Managed Instance. Therefore, the correct choice is option C. SQL Server on Azure Virtual Machines.

This needs correcting please, answer is D - Managed Instance

The correct answer is D. Managed Instance ensure the latest version of SQL Server, because offload you to managed patches and update. Managed Instance support SQL Server Agent and minimize administrative effort compared to manage a VM with SQL Server installed

MI as it minimizes admin effort

D. Azure SQL Managed Instance Here's why this option fits your requirements: Ensure that the latest version of SQL Server is used: Azure SQL Managed Instance runs the latest stable version of SQL Server and is automatically updated, so you do not need to manually upgrade SQL Server. Support the SQL Server Agent service: Azure SQL Managed Instance supports SQL Server Agent, which allows you to schedule jobs and automate tasks just like you would in an on-premises SQL Server environment. Minimize administrative effort: Azure SQL Managed Instance provides a fully managed database service that reduces administrative overhead. It handles most of the management functions such as upgrading, patching, backups, and monitoring without user intervention.

D is ok.

• Ensure that the latest version of SQL Server is used. MI has / SQL on VM has not • Support the SQL Server Agent service. MI has / SQL on VM has • Minimize administrative effort. MI wins over SQL on VM

Latest version available in MI

Latest version available in MI

Managed Instance - latest version (also Azure SQL) plus support for SQL Agent jobs.

Latest version available in MI

The answer is D. Because: ensure that the latest version of SQL Server is used. Only SQL MI is always in latest version. SQL on VM can be in previus version.

For administrative efforts to be minimized, Azure SQL Managed Instance is the correct answer.

Answer D https://learn.microsoft.com/en-us/sql/ssms/agent/set-service-startup-account-sql-server-agent-sql-server-configuration-manager?view=sql-server-ver16 Applies to: SQL Server and Azure SQL Managed Instance

In my opinion, both VM and MI ensure the latest version and support Agent service. MI requires less administrative effort so it should be the correct answer. Correct me if I am wrong.