You administer a Microsoft SQL Server environment. You purchase a new server and plan to migrate your database from SQL Server 2
008 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
Migration assistant also referred to as the Data Migration Assistant (DMA) is a Microsoft tool used during SQL server upgrades to detect any compatibility issues that could impact the functionality of the new version of SQL server being installed. The Data Migration Assistant will also recommend performance and reliability improvements as well as allow you to move your SQL server data and schema from the source server to the destination server.
The answer to this question is the PET scan. Positron
Emission Tomography or PET scan is an imaging test that checks and trace for
diseases in the body. This also shows how the body organs is functioning /
working. The doctor can evaluate the function of the patients body by the 3D
color images produced by the PET Scan.
