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?
Azure SQL Managed Instance fulfills all the requirements for migrating your Microsoft SQL Server 2017 server to Azure. It ensures that the latest version of SQL Server is used as it runs the latest stable version and is automatically updated, which minimizes the need for manual upgrades. It supports the SQL Server Agent service, allowing for the scheduling of jobs and automation of tasks, similar to an on-premises setup. Finally, it minimizes administrative effort as it is a fully managed database service that handles database management functions such as upgrading, patching, backups, and monitoring without significant user involvement.
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
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.
no you are right
100% right. SQL M.I is a (PaaS) database engine that handles most database management functions such as upgrading, patching, backups, and monitoring without user involvement. https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview?view=azuresql
This needs correcting please, answer is D - Managed Instance
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.
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
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
• 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
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.
https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/job-automation-managed-instance?view=azuresql-mi SQL Agent is supported on Azure SQL MI.
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 is wrong. It(ChatGPT) says that a SQL Server on Azure VM is less administrative effort than a SQL Managed Instance? A full SQL VM is far more overhead. This is very flawed and ChatGPT often gets confused. Read the free training material online. Answer is D.
MI as it minimizes admin effort
D is ok.
Latest version available in MI
Latest version available in MI
Managed Instance - latest version (also Azure SQL) plus support for SQL Agent jobs.