ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-764 All Questions

View all questions & answers for the 70-764 exam
Go to Exam

Exam 70-764 topic 1 question 257 discussion

Actual exam question from Microsoft's 70-764
Question #: 257
Topic #: 1
[All 70-764 Questions]

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.

  • 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.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
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 complex workflow 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 Database.
You can use SSIS data transfer packages with another mechanism for transferring the database schema, such as a Data-tier Application package.
Incorrect Answers:
D: Generate Scripts Wizard Has explicit option for Azure SQL Database scripts generation Data Transfer Efficiency: Poor Good for smaller database
- Using the Generate Scripts wizard to migrate a SQL Server database to Azure SQL Database should be limited to:
Teams who have experience with the wizard.
Migrating simple databases that need few schema changes to run on Azure SQL Database.
The scripts generated from the source database can be modified before being used to create the new version of the database on Azure SQL Database, but using a database project in the SQL Server Data Tools has richer support for making schema changes. Migrating small databases that do not have much data.
The wizard generates scripts that use insert statements instead of bulk copies to transfer the data. The insert statements can be throttled when the tables contain too much data, and are not as fast as bulk copies.
by TheSwedishGuy at Jan. 31, 2020, 5:16 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
TheSwedishGuy
5 years, 4 months ago
Just migrate via a SSIS package.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel