You have an Azure subscription that contains two instances of SQL Server on Azure Virtual Machines named VM1 and VM2. Both instances run Microsoft SQL Server 2019 CU8. You need to deploy a failover cluster instance (FCI) to VM1 and VM2. The solution must eliminate the need for the following:
• A distributed network name (DNN)
• A load balancer
What should you do?

A. Deploy VM1 and VM2 to a single proximity placement group.

B. Deploy VM1 and VM2 to different proximity placement groups in the same Azure region.

C. Connect VM1 and VM2 to a single subnet.

D. Connect VM1 and VM2 to different subnets on a single virtual network.

You have two instances of SQL Server on Azure virtual Machines named VM1 and VM2.
VM1 hosts a database named dbl.
You plan to create a database availability group (DAG) for dbl. The solution must use certificate authentication between VM1 and VM2.
You need to configure authentication for the outbound connections of VM1.
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.

You are designing an enterprise data warehouse in Azure Synapse Analytics that will store website traffic analytics in a star schema.
You plan to have a fact table for website visits. The table will be approximately 5 GB.
You need to recommend which distribution type and index type to use for the table. The solution must provide the fastest query performance.
What should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

You have an Azure subscription.
You need to deploy a logical SQL server by using PowerShell. The solution must ensure that the logical SQL server can create Azure AD users and provide Transparent Data Encryption (TDE} with a customer-managed key.
How should you complete the command? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

You have 25 Azure SQL databases.
You need to implement a centralized database management solution that uses Transact- SQL What should you include in the solution?

A. elastic jobs

B. an Azure Automation runbook

C. Azure Functions

D. Azure Logic Apps

You have an Azure subscription that contains an instance of SQL Server on an Azure virtual machine named VM1 and a Microsoft Entra Domain Services domain that contains two users named User1 and User2.
On the default instance of SQL Server on VM1, you create a credential named Credentiall for User1.
You need to ensure that User2 can create a SQL Server Agent proxy that will use Credential1. The solution must use the principle of least privilege.
Which role should you assign to User2?

A. sysadmin

B. SQLAgentUserRole

C. SQLAgentOperatorRole

D. SQLAgentReaderRole

You have an Azure subscription.
You need to deploy a new Azure SQL database by using Azure Command-Line Interface (CLI).
Which three parameters are required?

A. Option A

B. Option B

C. Option C

D. Option D

You have an Azure Data Factory instance named ADF1 and two Azure Synapse Analytics workspaces named WS1 and WS2.
ADF1 contains the following pipelines:
P1:Uses a copy activity to copy data from a nonpartitioned table in a dedicated
SQL pool of WS1 to an Azure Data Lake Storage Gen2 account
P2:Uses a copy activity to copy data from text-delimited files in an Azure Data
Lake Storage Gen2 account to a nonpartitioned table in a dedicated SQL pool of WS2
You need to configure P1 and P2 to maximize parallelism and performance.
Which dataset settings should you configure for the copy activity of each pipeline? To answer, select the appropriate options in the answer area.

You deploy an instance of SQL Server on Azure Virtual Machines named SQL1 that hosts multiple databases.
You configure the full recovery model for all the databases.
You perform a full backup of the master database on SQL1.
You need to a perform an additional backup of the master database on SQL1. The solution must minimize how long it takes to perform the backup.
Which type of backup should you perform?

A. tail-log

B. differential

C. full

D. log

You have an Azure subscription that contains a resource group named RG1. RG1 contains an instance of SQL Server on Azure Virtual Machines named SQL
You need to use PowerShell to enable and configure automated patching for SQL The solution must include both SQL Server and Windows security updates.
How should you complete the command? To answer, select the appropriate options in the answer area.