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 a on-premises Microsoft SQL Server named SQL1 that hosts five databases.
You need to migrate the databases to an Azure SQL managed instance. The solution must
minimize downtime and prevent data loss.
What should you use?

You need to recommend a configuration for ManufacturingSQLDb1 after the migration to
Azure. The solution must meet the business requirements.
What should you include in the recommendation? To answer, select the appropriate
options in the answer area.
NOTE: Each correct selection is worth one point.

You have an Azure SQL database named db1 on a server named server1.
You need to modify the MAXDOP settings for db1. What should you do?

You have an Azure Data Lake Storage Gen2 account named account1 that stores logs as shown in the following table.

You do not expect that the logs will be accessed during the retention periods.
You need to recommend a solution for account1 that meets the following requirements:
Automatically deletes the logs at the end of each retention period
Minimizes storage costs
What should you include in the recommendation? To answer, select the appropriate
options in the answer area.
NOTE: Each correct selection is worth one point

You deploy a database to an Azure SQL Database managed instance.
You need to prevent read queries from blocking queries that are trying to write to the database. Which database option should set?

Which windowing function should you use to perform the streaming aggregation of the
sales data?

You need to apply 20 built-in Azure Policy definitions to all new and existing Azure SQL
Database deployments in an Azure subscription. The solution must minimize administrative
effort.
Which three actions should you perform in sequence? To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.