Question 256

You have an Azure subscription.
Vou need to deploy two instances of SQL Server on Azure virtual machines in a highly available configuration that will use an Always On availability group. The solution must meet the following requirements:
* Minimize how long it takes to fail over.
* Maintain existing connections to the primary replica during a failover.
What should you do?
  • Question 257

    You have an Azure SQL database named D61.
    You need to identify how much unused space in megabytes was allocated to DB1.
    How should you complete the Transact-SQL query? To answer select the appropriate options m the answer area.
    NOTE: Each correct selection is worth one point.

    Question 258

    You create a new Azure SQL managed instance named SQL1 and enable Database Mail extended stored You need to ensure that SQ Server Agent jobs running on SQL 1 can notify when a failure Occurs Which three actions should you perform in sequence 7 TO answer. move the appropriate actions from the list Of actions to answer area and arrange them in correct order.

    Question 259

    Hotspot Question
    You have an Azure SQL database.
    You have a query and the associated execution plan as shown in the following exhibit.

    Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
    NOTE: Each correct selection is worth one point.

    Question 260

    You have an Azure SQL database named DB1 in the General Purpose service tier.
    You need to monitor D81 by using SQL insights.
    What should you include in the solution? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.