Exam DP-300 topic 1 question 76 discussion

Here is what Copilot said: The SQL Server IaaS Agent extension for Linux currently has limited functionality compared to its Windows counterpart. Specifically, it does not support automated backup on Linux Azure Virtual Machines For automated backups, you might need to consider alternative solutions such as using Azure Backup or configuring custom backup scripts to manage your SQL Server backups on Linux. The SQL Server IaaS Agent extension for Linux does not support automated patching. This feature is currently available only for SQL Server on Windows Azure VMs. For your SQL Server 2022 on Linux, you will need to manage patching manually or use other tools like Azure Update Management to handle updates.

>> Operating System: Ubuntu Linux https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/linux/sql-server-iaas-agent-extension-linux?view=azuresql&tabs=azure-powershell#limitations Limitations: The Linux SQL IaaS Agent extension has the following limitations: Only SQL Server VMs running on the Ubuntu Linux operating system are supported. Other Linux distributions are not currently supported. >> Benefit: Registration of a SQL virtual machine resource in Azure In below link, automated backups and patching are NOT present in the Benefits list for Linux: https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/linux/sql-server-iaas-agent-extension-linux?view=azuresql&tabs=azure-powershell

Operating system: Ubuntu Only SQL Server VMs running on the Ubuntu Linux operating system are supported. Other Linux distributions are not currently supported. Benefit: Registration of a SQL virtual machine resource in Azure The SQL Server IaaS Agent extension enables integration with the Azure portal... https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/linux/sql-server-iaas-agent-extension-linux

Operating System: Red Hat Enterprise Linux (RHEL) Benefit: Automatic backup