微软认证考试70432练习试题10[1]

【网络综合 - 微软认证(MCSE)试题】
无忧考网为大家收集整理了《微软认证考试70432练习试题10》供大家参考，希望对大家有所帮助！！！

QUESTION 46
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in
the instance. The latest differential backup is performed at 15:30, the full back up was performed at 13:30, and database snapshots were created at 16:30 and at 17:30. The backups and the
database snapshots are stored on a different disk from the database files. At 17:05, the hard disk containing the database files fails at 17:02 hours. You must restore DB1 while reduce data loss to
the least. So what action should you perform to achieve this goal?

A.You should restore the full backup
B.You should restore the database snapshot from 16:30 hours.
C.You should restore the database snapshot from 17:30 hours
D.You should restore both the full backup and the differential backup.
Answer: D

QUESTION 47
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in
the instance. There are data file and the transaction log file on the E: drive. Now you find that There isonly 6% spare space. Both files have to be moved to the V: drive. Which procedure should you
use?

A.You should run the following Transact-SQL statement. ALTER DATABASE DB1 SET RESTRICTED_USER WITH ROLLBACK_IMMEDIATE; Move the data file and transaction log file to the new
location.Run the following Transact-SQL statements. ALTER DATABASE DB1 MODIFY FILE(NAME = DB1_Data, FILENAME = 'v:\SQLServer\DB1_Data.mdf'); ALTER DATABASE DB1 SET
MULTI_USER;
B.You should terminate the SQL Server Service. Then move the data file and transaction log file to the new location. Start the SQL Server service. Run the following Transact-SQL statement.
EXEC sp_attach_DB @DB微软认证(MCSE)