當前位置: 首頁 > 問題分類 > 計算機類考試 > 微軟認證 > 問題詳情
問題

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?

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

參考答案
正確答案:D
解析: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 files

3. 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 your company's network. Your network has five Windows 2000 server computers and 75 Windows 2000 Professional computers. The Windows 2000 Professional computers were installed by using a RIS image on one of the Windows 2000 Server computers. You need to upgrade several applications on the Windows 2000 Professional computers. The applications do not have built-in support for scripted installations.

    You want to accomplish the following goals:

    1. An unattended installation of the upgraded applications will be performed on the Windows 2000 Professional computers.

    2. Existing user environments will be maintained on the Windows 2000 Professional computers.

    3. The network name of each Windows 2000 Professional computer will be changed to match its asset tag.

    4. The RIS image and the upgraded applications will be enabled as they are added to the network.

    You take the following actions:

    1. Install the RIS image on a Windows 2000 Professional computer named Computer1.

    2. Install the upgraded applications on Computers1.

    3. Change the network name of Computer1 to %DMI-SERIAL_NUM%.

    4. Run RIPrep.exe on Computer1 to load the RIS image on to the RIS server.

    5. Start all of the Windows 2000 Professional computers, and then load the RIS image from the RIS server.

    Which result or results do these actions produce? (Choose all that apply.)

    A.An unattended installation of the upgraded applications will be performed on the Windows 2000 Professional computers.

    B.Existing user environments will be maintained on the Windows 2000 Professional computers.

    C.The network name of each Windows 2000 Professional computer will be changed to match its asset tag.

    D.The RIS image and the upgraded applications will be enabled as they are added to the network.

  • You are the administrator responsible for security and user desktop settings on your network. You need to configure a custom registry entry for all users. You want to add the custom registry entry into a Group Policy object (GPO) with the least amount of administrative effort.

    What should you do?

    A.Configure an ADM template and add the template to the GPO.

    B.Configure an INF policy and add the policy to the GPO.

    C.Configure a Microsoft Windows installer package and add the package to the GPO.

    D.Configure RIS to include the registry entry.

  • You are the network administrator for Ezonexam. The network consists of a single Active Directory domain Ezonexam.com. All network servers run Windows Server 2000.

    Your network includes a shared folder named EzonexamDocs. This folder must not be visible in a browse list.

    However, users report that they can see EzonexamDocs when they browse for shared folders.

    How should you solve this problem?

    A.Modify the share permissions to remove the All - Read permission on EzonexamDocs from the Users group.

    B.Modify the NTFS permissions to remove the Allow - Read permissions on EzonexamDocs from the Users group.

    C.Change the share name to EzonexamDocs #.

    D.Change the share name to EzonexamDocs $.

  • On a Windows 2000 Professional computer, you run a shipping application that prints packing labels to a laser printer for every outgoing shipment, 24 hours per day. During peak hours, your company ships more than 1,000 packages per hour.

    You have just purchased a second identical laser printer to aid in printing. You want to configure the printers so that the jobs are load balanced. You connect the second laser printer to the computer.

    What must you do next?

    A.Enable bi-directional support.

    B.Enable printer pooling.

    C.Configure print spooling.

    D.Configure print sharing.

×
驗證
新疆十一选五和值表