Question 191

You have SQL Server on an Azure virtual machine.
You review the query plan shown in the following exhibit.

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

Question 192

You have an Azure subscription that contains an Azure SQL database named SQLDb1. SQLDb1 contains a table named Table1.
You plan to deploy an Azure web app named webapp1 that will export rows in Table1 that have changed.
You need to ensure that webapp1 can identity the changes to Table'. The solution must meet the following requirements:
* Minimize compute times.
* Minimize storage.
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.

Question 193

You have an on-premises Microsoft SQL server that uses the FileTables and Filestream features.
You plan to migrate to Azure SQL.
Which service should you use?
  • Question 194

    Note: This question is part of a series of questions that present the same scenario. Each question in
    the series contains a unique solution that might meet the stated goals. Some question sets might have
    more than one correct solution, while others might not have a correct solution.
    After you answer a question in this section, you will NOT be able to return to it. As a result, these
    questions will not appear in the review screen.
    You have an Azure SQL database named Sales.
    You need to implement disaster recovery for Sales to meet the following requirements:
    * During normal operations, provide at least two readable copies of Sales.
    * Ensure that Sales remains available if a datacenter fails.
    Solution: You deploy an Azure SQL database that uses the General Purpose service tier and failover groups.
    Does this meet the goal?
  • Question 195

    You need to configure user authentication for the SERVER1 databases. The solution must meet the security and compliance requirements.
    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.