為大家收集整理了《微軟認(rèn)證考試70-432練習(xí)試題19》供大家參考，希望對大家有所幫助?。。?BR>    QUESTION 91 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 92 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 cluster. According to the company requirement, the failover response of the cluster has to be tested. The company assigns this task to you. On the cluster, you have to implement a manual failover. What should you do? (choose more than one) A.The contents of a shared folder on the active node should be encrypted by using Encrypting File System (EFS) B.You should restore a backup to the active node C.You should get rid of the shared array from the active node D.From the active node, you have to uplug the network cable(s) Answer: CD QUESTION 93 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. You configure the SQL Server instance to use the -T1222 and -T1204 trace flags during startup. You must make sure that your failure recovery plan performs backup of the use of the trace flags. So what action should you perform to achieve this goal? A.You should backup the master database B.You should backup the default.trc file C.You should backup the SQL Server registry hive. D.You should backup the resource database Answer: C QUESTION 94 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 95 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. You have set the recovery model of DB1 to Full. The table below shows the backup strategy for DB1. Your company stores the system databases, user database data, and log files on separate disks. A user report that the hard disks which store the user database data files have failed at 15:00 on Wednesday. According to the requirement of the company CIO, you have to restore Tdb1from the database backups, and you must reduce the data loss as soon as possible. So what action should you perform to achieve this goal? A.First you should restore the full backup taken on Sunday. Then you restore the differential backup taken on Wednesday. B.First you should back up the transaction log. Then restore the full backup taken on Sunday. At last restore all transaction log backups C.First you should back up the transaction log. Second, restore the full backup taken on Sunday. Third, restore the differential backup taken on Tuesday and restore all transaction log backups taken during Wednesday. D.First you should restore the full backup taken on Sunday. Then restore the differential backup taken on Monday and Tuesday and restore the transaction log backups taken at 08:00 hours and at 12:00 hours on Wednesday. Answer: C