Provisioning SQL Databases — Question 53

You plan to migrate on-premises Microsoft SQL Server databases to SQL Server on a Microsoft Azure virtual machine.
A full back up of the databases is 3 TB. The corporate network has a 1.5 MB/sec Internet connection.
You need to move the backups to Azure to ensure that you can restore the databases to the Azure virtual machine as quickly as possible.
What should you do?

Answer options

• A. Use SQL Server Backup to URL. parameter.
• C. Create an availability group that is configured for automatic seeding. parameter.
• E. Use the Azure Import/Export service.

Correct answer: E

Explanation

The correct choice is E, as the Azure Import/Export service allows for physically shipping the backup files to Azure, which is much faster than transferring over a slow Internet connection. Option A is not suitable because SQL Server Backup to URL would still require the limited Internet bandwidth, and option C does not address the need for fast data migration as it pertains to database availability rather than backup transfer.