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.You want to ensure that the journalists can query the database. What should you do? -题库考试答案搜索网

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.You want to ensure that the journalists can query the database. What should you do?

单选题

2023-03-20 17:07

A、Create a new full-text catalog for the Articles database
B、Rebuild the full-text catalog for the Articles database
C、Create a new full-text index on the table that holds the text for the articles
D、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.Note 1:Setting up a full-text search is a three-step procedure:1. Make sure that the full-text indexing feature has been installed with your SQL Server.The full-text index is installed as a service in the system. It would not have to be reinstalled after restoring a database.2. Create a catalog in the operating system to store the full-text indexes.A catalog can contain the indexes from one or more tables, and it is treated as a unit for maintenance purposes. In general, you shouldn't need more than one catalog per database.The catalog is saved outside the database on separate files3. Before you can implement a full-text search in a given database, you must ensure that the full-text search indexes are populated regularly.In this scenario we must recreate the index by repopulating the full-text catalog.Note 2: A SQL Server 2000 full-text index provides support for sophisticated word searches in character string data. The full-text index stores information about significant words and their location within a given column. This information is used to quickly complete full-text queries that search for rows with particular words or combinations of words. The full-text indexes are contained in full-text catalogs. Full-text catalogs and indexes are not stored in the database to which they belong. The catalogs and indexes are managed separately by the Microsoft Search service. Backing up a database does not back up full-text index data in full-text catalogs. However, if full-text indexes have been defined for tables, the meta. data is backed up when a database backup is created.Incorrect Answers:A: The catalog already exists. The catalog is stored outside SQL server and would not be affected by the failure and restoration of the database.B: Rebuildning the full text catalog will not enable the Journalist to run the full-text queries. The catalogs would have to be repopulated as well.C: The index should be repopulated since it already exists from the backup. There is no need to recreate it.

标签：

感兴趣题目

You are the administrator of a SQL Server 2000 computer. You have two new hard disks on which you will create a database named inventory. You want to insert, update, and delete data as quickly as possible.

You are the network administrator for All servers run Windows Server 2003.
You are creating a backup schedule for the main file server.
You need to create a schedule so that backup jobs are completed in the shortest
amount of time possible.
What should you do?（）

You are the network administrator for Ezonexam. You are planning to upgrade 35 Windows NT Server 4.0 computers to Windows 2000 Server. You want to accomplish the upgrades by using a distribution server. The Windows NT Server 4.0 computers support a tight production schedule that requires them to be online from 8:00 A.M. to midnight, seven days a week. You schedule the upgrade to run during non-business hours. Because of the limited amount of time the upgrades must be performed as quickly as possible.You want to complete the upgrades before production begins in the morning.What should you do?

You are the network administrator for your company. The network consists of a single Active Directory domain.All servers run Windows Server 2003.You place computer accounts for servers in organizational units (OUs) that are organized by server roles. You apply Group Policy objects (GPOs) to these servers at the OU level.You need to add a new server to the domain. You need to ensure that the appropriate GPOs are applied to this server.What should you do? （）

You are a network administrator for All servers run Windows Server 2003.
A network server named Testking1 functions as the main file server. Testking1 is backed up each night by using the Backup utility. You perform a test restoration of Testking1 by using the Backup utility. You discover that files that are open during the backup process are not being backed up.
You need to ensure that open files are backed up successfully.
What should you do?（）

You are a network administrator for your company. All servers run Windows Server 2003.
A network server named Server1 functions as the main file server. Server1 is backed up each night by using the Backup utility. You perform a test restoration of Server1 by using the Backup utility. You discover that files that are open during the backup process are not being backed up.
You need to ensure that open files are backed up successfully.
What should you do? （）

You are the desktop administrator of your Windows 2000 Professional computer.

You are the network administrator for All servers run Windows Server 2003. You are creating a backup schedule for the main file server. You need to create a schedule so that backup jobs are completed in the shortest amount of time possible. What should you do?（）

You are planning the migration of an existing application to Windows Azure and SQL Azure. The current application includes reports that are hosted by SQL Server Reporting Services. You need to recommend an approach for migrating the reports. What should you recommend？（）

You are employed as the exchange administrator at Company.com.the Company.com organization makes use of microsoft exchange server 2010 as their messaging solution.Company.com has its headquarters in stockholm where you are located.you are responsible for an exchange server 2010 mailbox server named - ex01.during the course of the day you receive notification from management to determine which users that have the biggest mailboxes on - ex01.What should you do？（）

You are a database administrator in the Los Angeles branch office of a specialty foods supplier. A mainframe. database at the headquarters contains all company data. Each branch office contains a SQL Server 2000 computer that imports regional data from the mainframe. database.The server in Los Angeles contains a Data Transformation Services (DTS) package that uses OLE DB to connect to the company's mainframe. database. The DTS package extracts and transforms data about buyers and products for that region. The DTS package then writes the data to the SQL Server database in Los Angeles.You need to configure a SQL Server computer for the new branch office in Sydney. You want to copy the Los Angeles package and modify it so that it writes data to the SQL Server database in Sydney.You use the DTS Designer to modify the DTS package so that it imports regional data from the mainframe. database to the server in Sydney. The modified DTS package runs successfully on the server in Los Angeles. You save this DTS package to the server in Sydney, but the server in Sydney cannot connect to the mainframe. database.You want to enable the server in Sydney to connect to the mainframe. database. What should you do?

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.You want to ensure that the journalists can query the database. What should you do?