Administering Microsoft SQL Server 2012/2014 Databases — Question 2

You maintain several databases on a 32-bit Microsoft SQL Server 2005 instance on a Windows Server 2008 R2 64-bit server.
You need to migrate the databases to a 64-bit SQL Server 2012 instance on the same server. You also need to ensure that the new Transact-SQL functionality in
SQL Server 2012 can be used in the database after the migration.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

Answer options

• A. Perform a side-by-side installation of a 32-bit SQL Server 2012 instance.
• B. Perform a side-by-side installation of a 64-bit SQL Server 2012 instance.
• C. Perform an in-place upgrade to 64-bit SQL Server 2012.
• D. Detach the database from the old instance and attach it to the new instance.
• E. Change the compatibility level of the database. BDE

Correct answer:

Explanation

To utilize the new features of SQL Server 2012, you must migrate to a 64-bit instance, making option B and option D correct. Option A is incorrect because a 32-bit version won't allow access to the new features. Option C is also incorrect as an in-place upgrade from 32-bit to 64-bit is not supported. Option E is necessary after migration, but it doesn't address the migration process itself.