Hotspot Question
You have two Azure virtual machines named VM1 and VM2 that run Windows Server 2019. VM1 and VM2 each host a default Microsoft SQL Server 2019 instance. VM1 contains a database named DB1 that is backed up to a file named D:\DB1.bak.
You plan to deploy an Always On availability group that will have the following configurations:
- VM1 will host the primary replica of DB1.
- VM2 will host a secondary replica of DB1.
You need to prepare the secondary database on VM2 for the availability group.
How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.

You have an Azure Databricks resource.
You need to log actions that relate to changes in compute for the Databricks resource.
Which Databricks services should you log?

Hotspot Question
You have an Azure SQL database that contains a table named Customer. Customer has the columns shown in the following table.

You plan to implement a dynamic data mask for the Customer_Phone column. The mask must meet the following requirements:
- The first six numerals of each customer's phone number must be
masked.
- The last four digits of each customer's phone number must be visible.
- Hyphens must be preserved and displayed.
How should you configure the dynamic data mask? To answer, select the appropriate options in the answer area.

You have an Azure subscription.
You plan to deploy an instance of SQL Server on Azure Virtual Machines by using an Azure Marketplace image.
You need to register the SQL Server IaaS Agent extension (SqlIaasExtension). The solution must meet the following requirements:
- Install critical updates for SQL Server automatically.
- Minimize performance impact on the virtual machine.
Which management mode should you select?

You have the following Transact-SQL query.

Which column returned by the query represents the free space in each file?