Question 171

You have an Azure SQL database named sqldb1.
You need to minimize the amount of space by the data and log files of sqldb1.
What should you run?
  • Question 172

    You have SQL Server on an Azure virtual machine that contains a database named Db1.
    You need to enable automatic tuning for Db1.
    How should you complete the statements? To answer, select the appropriate answer in the answer area.
    NOTE: Each correct selection is worth one point.

    Question 173

    DRAG DROP
    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.
    Select and Place:

    Question 174

    You have an on-premises Microsoft SQL Server 2016 server named Server1 that contains a database named DB1.
    You need to perform an online migration of DB1 to an Azure SQL Database managed instance by using Azure Database Migration Service.
    How should you configure the backup of DB1? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    Question 175

    You have an on-premises multi-tier application named App1 that includes a web tier, an application tier, and a Microsoft SQL Server tier. All the tiers run on Hyper-V virtual machines.
    Your new disaster recovery plan requires that all business-critical applications can be recovered to Azure.
    You need to recommend a solution to fail over the database tier of App1 to Azure. The solution must provide the ability to test failover to Azure without affecting the current environment.
    What should you include in the recommendation?