You have an Azure SQL database named DB1 in the General Purpose service tier.The performance metrics for DB1 are shown in the following exhibit. You need to reduce the Log 10 percentage. The solution must minimize costs.What should you do?

Change Service tier to Business Critical.

Change Recovery model to Simple.

Perform a checkpoint operation.

Change Service tier to Business Critical.

You have an Azure SQL Database elastic pool that contains 10 databases.You receive the following alert.Msg 1132, Level 16, State 1, Line 1The elastic pool has reached its storage limit. The storage used for the elastic pool cannot exceed (76800) MBs.You need to resolve the alert. The solution must minimize administrative effort.Which three actions can you perform? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.

Remove a database from the pool.

Increase the maximum storage of the elastic pool.

Remove a database from the pool.

Increase the maximum storage of the elastic pool.

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 balancerWhat should you do?

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

Deploy VM1 and VM2 to a single proximity placement group.

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

Connect VM1 and VM2 to a single subnet.

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

You plan to deploy two instances of SQL Server on Azure virtual machines in a highly available configuration that will use an Always On availability group.You need to recommend a deployment solution that meets the following requirements:* Provides a Service Level Agreement (SLA) of at least 99.95%* Replicates databases in the same group synchronously* Minimizes the latency of database writesWhat should you recommend?

Create a proximity group and an availability set. Deploy each virtual machine to the availability set Add both virtual machines to the proximity group.

Create two proximity groups and a single availability set. Deploy both virtual machines to the availability set. Add one virtual machine to each proximity group.

Create two proximity groups and two availability sets. Deploy each virtual machine to a unique availability set. Add one virtual machine to each proximity group.

Create a proximity group and two availability sets. Deploy each virtual machine to a unique availability set. Add both virtual machines to the proximity group.

You have an Azure subscription that contains an Azure SQL database. The database contains a table named tablet.You execute the following Transact-SQL statements. You need to reduce the time it takes to perform analytic queries on the database.Which configuration should you enable?

ROW_ MODE_MEMORY GRANT_FEEDBACK

BATCH MODE_MEMORY GRAIJT_FEEDBACK

You have an instance of SQL Server on Azure Virtual Machines named SQL1.SQL1 contains an Extended Events session named session! that captures Microsoft SQL Server events.You need to correlate the session events with events captured by Event Tracing for Windows (ETW).What should you do for session1?

Modify the Set Session Event Filters settings.

Modify the Specify Session Data Storage settings.

You have an on-premises datacenter that contains a 14-TB Microsoft SQL Server database.You plan to create an Azure SQL managed instance and migrate the on-premises database to the new instance.Which three service tiers support the SQL managed instance? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Business Critical Memory Optimized Premium

You have an instance of SQL Server on Azure Virtual Machines named VM1.You need to implement a disaster recovery solution that meets the following requirements:* Returns the solution to an operational state within 15 minutes of a failure* Can perform disaster recovery testing in an isolated environment* Minimizes administrative effortWhat should you include in the solution?

a failover cluster instance (FCI)

You have an Azure subscription.You create a logical SQL server that hosts four databases Each database will be used by a separate customer.You need to ensure that each customer can access only its own database. The solution must minimize administrative effortWhich two actions should you perform? Each correct answer presents part of the solutionNOTE: Each correct selection is worth one point.

Create a database-level firewall rule.

Create a network security group (NSG)

Create a server-level firewall rule

Create a database-level firewall rule.