DP-300 Certification Practice Question #62

Question

You plan to deploy an instance of SQL Server on Linux Azure Virtual Machines. The instance will run Microsoft SQL Server 2022 and use the SQL Server IaaS Agent extension for Linux.

Which Linux operating system should you deploy, and which benefit will the SQL Server IaaS Agent extension provide? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Accepted Answer

The SQL Server IaaS Agent extension on Linux is only supported on the Ubuntu Linux operating system (RHEL and SLES are not supported for the extension). Furthermore, the Linux version of the extension has limited features compared to its Windows counterpart; it does not support features like Automatic backup or Automatic patching. Instead, registering the VM with the extension provides the benefit of creating a dedicated SQL virtual machine resource in Azure, which allows for unified management and licensing configurations like Azure Hybrid Benefit.

More DP-300 practice questions