Question 156

You have an Azure SQL Database managed instance named sqldbmi1 that contains a database name Sales.
You need to initiate a backup of Sales.
How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Question 157

You have a Microsoft SQL Server 2017 server that hosts five databases.
You Plan to migrate the databases to Azure.
You need to recommend a solution that meets the following requirements:
* Automatically scales compute based on the workload demand
* Provides per-second billing
What should you include in the recommendation? To answer, select the appropriate options in the answer area.

Question 158

You have an Azure SQL database.
You need to implement a disaster recovery solution that meets the following requirements:
* Minimizes how long it takes to recover the database if a datacenter fails
* Minimizes administrative effort
What should you include in the solution?
  • Question 159

    You have a Microsoft SQL Server database named DB1 that contains a table named Table1.
    The database role membership for a user named User1 is 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 160

    You have the following Azure Resource Manager template.

    For each of the following statements, select Yes if the statement is true. Otherwise, select No.
    NOTE:Each correct selection is worth one point.