Home » Microsoft » 70-473 » What should you include in the recommendation?
You need to recommend a backup solution for the ListTest database. What should you include in the recommendation?
A. Extract a data-tier application (DAC).
B. Use the bcp command.
C. Use the SQL Server Migration Assistant (SSMA).
D. Exporta data-tier application (DAC).
Correct Answer: D
Explanation/Reference:
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 theAzure virtual machine.
D.Implement merge replication between the main office and the Azure virtual machine.
Answer: B