Exam 70-462 topic 2 question 83 discussion

Actual exam question from Microsoft's 70-462

Question #: 83
Topic #: 2

You administer a Microsoft SQL Server environment. You purchase a new server and plan to migrate your database from SQL Server 2008 to SQL Server 2012.
You want to evaluate to prepare for possible conflicts and issues that may arise during or after the migration.
Which SQL Server tool should you use?

A. Distributed Replay
B. Migration Assistant
C. Data Tools
D. Upgrade Advisor D

Show Suggested Answer

Suggested Answer: Explanation 🗳️

by Varad at Oct. 1, 2019, 4:02 a.m.

Comments

Submit Cancel

RGataullin

5 years, 3 months ago

SQL Server Upgrade Advisor helps you prepare for upgrades to SQL Server 2014. Upgrade Advisor analyzes installed components from earlier versions of SQL Server, and then generates a report that identifies issues to fix either before or after you upgrade. The Data Migration Assistant (DMA) helps you upgrade to a modern data platform by detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database. DMA recommends performance and reliability improvements for your target environment and allows you to move your schema, data, and uncontained objects from your source server to your target server. I think the answer should be B. Since the description tells us that we are going to migrate and we need to find out whether we have any issues after migrating a database.

upvoted 2 times

...

Varad

5 years, 9 months ago

D. Upgrade Advisor

upvoted 4 times

...