Microsoft Exam Questions

Which of the following actions should you take?

You work as a database administrator at ABC.com. ABC.com has recently upgraded from SQL
Server 2000 to SQL Server 2008 R2.
A database, named ABCClients, was detached prior to the upgrade. ABCClients is made up of 12

data files. You have been instructed to make sure that ABCClients is usable on the SQL Server
2008 R2 instance.
Which of the following actions should you take?

A.
You should consider making use of the sp_attach_db Transact-SQL statement.

B.
You should consider making use of the CREATE DATABASE Transact-SQL statement.

C.
You should consider making use of the sp_detach_db Transact-SQL statement.

D.
You should consider making use of the ALTER DATABASE Transact-SQL statement.

Explanation: