QUESTION 19
A solution for the data warehouse system must be created to provide disaster recovery between SQL03 and an Azure virtual machine named SQL04. You need to recommend an auditing solution that meets the business goals. Which three events should you include in the recommendation? Each correct answer presents part of the solution.

QUESTION 16
You need to recommend a solution to migrate the Listings database to the cloud. What should you recommend?

A. Stage the Listings database on an Azure virtual machine prior to the outage.
During the outage, perform a data import from the main office by using SQL Server Management Studio.
B. Implement log-shipping between the main office and an Azure virtual machine prior to the migration date. During the planned outage, perform a final log backup, restore the backup to the secondary, and then switch the secondary to the primary role.
C. Run a full backup during the outage and restore the backup to the Azure virtual machine.
D. Implement merge replication between the main office and the Azure virtual machine.

QUESTION 13
Drag and Drop Question
You need to back up the Listings database to meet the high-availability and recovery 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.

QUESTION 10
Drag and Drop Question
You need to configure auditing to meet the technical 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.

QUESTION 7
Your company has two offices. The offices are located in London and New York. The London office has a public IP of 131.107.1.1 and a private IP subnet of 192.168.4.0/24. The New York office has a public IP of 131.107.15.1 and a private IP subnet of 192.168.8.0/24. You have a Microsoft SQL Server database that is hosted on a Microsoft Azure virtual machine. Currently, only the users in the London office use the database. You need to create a new firewall rule to provide the users in the New York office with access to the database. The solution must protect the database from being accessed by users on the public Internet. What should you do?

A. Modify the endpoint from the Azure portal.
B. Use the sp_set_database_firewall_rule stored procedure.
C. Disable the Windows Firewall on the Azure virtual machine.
D. Run the New-AzureSqlDatabaseServerFirewallRule Azure PowerShell cmdlet.
E. Use the Set Firewall Rule REST API.