[单选题]You are the administrator of a SQL Server 2000 database named Articles. A large city newspaper uses this database to store its archived newspaper articles. Journalists query the database as part of their research. You have created full-text indexes so that users can query the articles quickly.A hardware failure forces you to restore the entire database from backup. After you restore the database, the journalists report that they can no longer run queries without receiving errors.

正确答案 ：E

Repopulate the full-text index on the table that holds the text for the articles

解析：解析：Explanation: Backing up a database does not back up full-text index data in full-text catalogs. The full-text catalog files are not recovered during a Microsoft SQL Server recovery. However, if full-text indexes have been defined for tables, the metadata for the full-text index definitions are stored in the system tables in the database containing the full-text indexes. After a database backup is restored, the full-text index catalogs can be re-created and repopulated.

[单选题]You are the network administrator for Ezonexam.Your Windows 2000 Server computer named Ezonexam1 contains two 36-GB hard disks. Disk 0 and Disk 1. Each disk is configured as a basic disc and has a single 36-GB NTFS partition. Both partitions are backed up to a tape each night. The partition on Disk 1 stores user data. Most users at Ezonexam encrypt their files. Disk 1 fails. You replace it with a new hard disk and create a single NTFS partition.

正确答案 ：E

Restore the contents of Disk 1 from the most recent tape backup to the new partition on Ezonexam1. Instruct the users to verify the integrity of their files.

解析：解析：Explanation:VerifyDataAfterBackupisusedtoconfirmthatfilesarecorrectlybackedup.WindowsBackupcomparesthebackupdataandthesourcedatatoverifythattheyarethesame.Microsoftrecommendsthatyouselectthisoption.RestoringthecontentsofDisk1fromthemostrecentbackuptapetothenewpartitiononEzonexam1andinstructingtheuserstoverifytheintegrityoftheirfileswouldaccomplishthetaskathandthequickestandstillmaintainthesecurityofthefilesofDisk1.Incorrectanswers:A:Thereisnoneedtomakeuseofasecondfileserver.Thiswillnotaccomplishthetaskasquickaspossible.Besides,thisdoesnotmeanthatthesecurityonthefileswillbekeptintact.B:Thereisnoneedtomakeuseofasecondfileserver,neitherasarecoveryagentandthencopyingfilesfromthesecondfileservertothenewpartition.Thiswilltaketoolonginthiscase.D:Thefirstpartofthisoptioniscorrect;buttheciphercommandisusedtodecryptfiles.

查看原题 点击获取本科目所有试题