微软认证考试70-432练习试题14[1]

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

QUESTION 66
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 which contains a database.
According to the company requirement, you have to move the application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You have to monitor the SQL Server instance to record the
use of features. These features will be discontinued. What should you do?

A.The SQL Server 2008 Upgrade Advisor should be used.
B.The SQL Server Profiler which captures the SQL:BatchCompleted and Exception event classes should be used.
C.A SQL server-side trace that captures the Deprecation Announcement and Deprecation Final Support event classes should be used
D.A SQL server-side trace that captures the SQL:BatchCompleted and Exception event classes should be used.
Answer: C

QUESTION 67
You work in a company which is named Wiikigo Corp. The company 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. DB1 has two filegroups: one is a filegroup named History that contains historical data stored in the G: volume; the other is the PRIMARY
filegroup that contains the On-Line Transaction Processing (OLTP) data stored in the F: volume. The backup strategy of DB1 has three requirements: first, the History filegroup should be backed up
at the end of each working day; second, the PRIMARY filegroup should be backed up five times a day; third, the transaction log should be backed up every quarter. You get a report at 13:00 saying
that the volume which contains the History filegroup fails.
As the technical support, you have to restore the database, and you must reduce the data loss to the least as soon as possible.
What should you do?

A.You shou微软认证(MCSE)