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 Database. Which method should you…

Question

Options

• ACreate a SQL ServerIntegration Services (SSIS) package, and then run the package.
• BBack up the database, and then restore the database.
• CExtract a data-tier application, and then import the application.
• DGenerate scripts to create all of the all database objects and all of the data, and then execute

• A
  82% (37)
• B
  4% (2)
• C
  2% (1)
• D
  11% (5)

Explanation

SQL Server Integration Services Most flexibility Data Transfer Efficiency: Good / SSIS can be used to perform a broad range of data migration tasks. SSIS provides support for complexworkflow and data transformation between the source and destination. It is a good choice to transfer of data for databases that require many changes to work on Microsoft Azure SQL You can use SSIS data transfer packages with another mechanism fortransferring the database schema, such as a Data-tier Application package. SSIS for Azure and Hybrid Data Movement

No community discussion yet for this question.