Administering a SQL Database Infrastructure — Question 173

You have a database hosted on SQL Server 2012 R2.
The database contains 5 million rows.
You need to recommend a repeatable method to migrate the database to SQL Azure.
Which method should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.

Answer options

• A. Create a SQL Server Integration Services (SSIS) package, and then run the package.
• B. Back up the database, and then restore the database.
• C. Extract a data-tier application, and then import the application.
• D. Generate scripts to create all of the all database objects and all of the data, and then execute the scripts by using SQL Azure.

Correct answer: A

Explanation

The correct answer is A because using SQL Server Integration Services (SSIS) allows for a structured and repeatable migration process, which is ideal for handling large datasets like 5 million rows. Options B and C are not feasible for SQL Azure, as SQL Azure does not support direct database restoration from SQL Server backups, and extracting a data-tier application may not cover all aspects of the database. Option D, while possible, is less efficient and more prone to errors than using SSIS.