Running SQL Server on an Azure virtual machine is an infrastructure-as-a-service (IaaS) approach, whereas Azure SQL Managed Instance is a platform-as-a-service (PaaS) approach. Which statement correctly describes the difference in management responsibility between the two?
- AWith SQL Server on an Azure VM the customer manages the operating system and SQL Server, including updates and backups, while a PaaS option has those tasks fully automated by the service. Correct
- BWith SQL Server on an Azure VM the service automates operating system patching and backups for the customer, while the PaaS option is the one that requires the customer to patch the operating system manually.
- CBoth the Azure VM option and the PaaS option leave operating system and SQL Server patching entirely to the customer, with no automation in either case.
- DBoth the Azure VM option and the PaaS option fully automate operating system and SQL Server maintenance, so management responsibility is identical for the customer.
Why A is correct: Correct. SQL Server on an Azure VM is an IaaS solution where the customer must manage all aspects of the server, including the operating system and SQL Server updates, configuration, backups, and other maintenance tasks.
Why B is wrong: This reverses the actual responsibilities. The VM (IaaS) option requires the customer to manage operating system and SQL Server maintenance, and the PaaS option is the one that automates updates and backups.
Why C is wrong: Only the VM (IaaS) option leaves the customer fully responsible for the operating system and SQL Server; the PaaS option provides fully automated updates, backups, and recovery, so the claim about the PaaS side is wrong.
Why D is wrong: The two options differ: the VM (IaaS) option requires the customer to manage the operating system and SQL Server, so responsibility is not identical, even though the PaaS option does automate that maintenance.