当前位置: 首页 > 问题分类 > 计算机类考试 > 微软认证 > 问题详情
问题

You are the administrator of a SQL Server 2000 computer. The server is configured as shown in the Database Server Configuration exhibit.

You need to create a new database named Inventory. Employees in your company will use the Inventory database to track inventory data. Users will require immediate responses to queries that help them locate where parts are stored. The tables in the database will be configured as shown in the Database Schema exhibit.

The database will consume 14 GB of disk space. You must configure the data files and transaction log to accelerate query response time.

Which two courses of action should you take? (Each correct answer represents part of the solution. Choose two.)

A. On drive C, create a transaction log.

On drive D, create a data file in the PRIMARY filegroup.

On drive E, create a data file in the SECONDARY filegroup.

B. On each drive, create a transaction log.

On each drive, create a data file in the PRIMARY filegroup.

C. On drive D, create a transaction log.

On drive E, create a data file in the PRIMARY filegroup.

D. On the PRIMARY filegroup, create all tables and all indexes.

E. On the PRIMARY filegroup, create all tables. On the SECONDARY filegroup, create all indexes.

F. On the PRIMARY filegroup, create the Parts table and its indexes.

On the SECONDARY filegroup, create all other tables and their indexes.

参考答案
正确答案:AE
A,E 解析:Explanation:
A: The transaction log should be placed on a separate disk. A transaction log would not benefit of two or more disks since it is sequential. Create two data files on two separate physical disks would improve performance.

E: Separating the tables and the indexes improve performance for in particular joins.

Note: With SQL Server 2000 it is possible to create tables or indexes on specific filegroups. This allows us to control where the database's tables and indexes are physically located as filegroups can be placed on different hard drives. Placing tables in one filegroup and the table's nonclustered indexes in another filegroup on different physical disk can improve database performance because it will allow separate threads to access the tables and indexes.

However, a table and its clustered index cannot be separated into different filegroups as the clustered index determines the physical order of the data in the table. Furthermore, the transaction log should be placed on a physically separate disk. The transaction log file is written serially; therefore, using a separate, dedicated disk allows the disk heads to stay in place for the next write operation. This will further improve performance.

Incorrect Answers:
B: To improve performance, the transaction log should not be placed on the same physical disk that the tables or indexes are placed on. The transaction log file is written serially; therefore, placing it on a separate, dedicated disk allows the disk heads to stay in place for the next write operation and thus improves performance.

Furthermore, placing tables in one filegroup and the table's nonclustered indexes in another filegroup on different physical disk can improve database performance because it will allow separate threads to access the tables and indexes. However, a table and its clustered index cannot be separated into different filegroups as the clustered index determines the physical order of the data in the table.

C: The transaction log should be placed on a physically separate disk. The transaction log file is written serially; therefore, using a separate, dedicated disk allows the disk heads to stay in place for the next write operation. This will further improve performance. In this solution, the tables and their indexes are placed on the same disk. This solution thus does not take advantage of the performance improvements that can be realised through the correct utlization of the available hardware.

D: In this solution, the tables and their indexes are placed on the same disk. This solution thus does not take advantage of the performance improvements that can be realised through the correct utlization of the available hardware.

F: Greater performance gains can be realized by placing tables in one filegroup and the table’s nonclustered indexes in another filegroup on different physical disk. This will allow separate threads to access the tables and indexes.
您可能感兴趣的试题
  • You recently upgraded all Windows NT Workstation 4.0 computers to Windows 2000 Professional. You want to give a new employee named Maria the ability to back up files, share resources, and install programs on a client computer that she shares with other users. You do not want Maria to be able to read other users' files.

    What should you do to accomplish these goals? (Choose all that apply)

    A.Add Maria's user account to the System group.

    B.Add Maria's user account to the Interactive group.

    C.Add Maria's user account to the Power Users group.

    D.Add Maria's user account to the Administrators group.

    E.Add Maria's user account to the Backup Operators group.

  • From your Windows 2000 Professional computer, you need to print from a 16-bit accounting application to a network printer named Printer02. Printer02 is attached to a print server named PrtSrv. The accounting application allows you to print only to a local LPT port.

    You currently have two printers attached to your local LPT1 and LPT2 ports. You need to be able to print to the network printer and to both local printers. You install the driver for the network printer on your computer.

    What must you do next to enable printing on the network printer?

    A.Create a new local printer port named PrtSrv\Printer02, and configure the printer to use the new port.

    B.Create a new local printer port named PrtSrv\Printer02. In the properties for the new port, select the option to print directly to the printer. Configure the printer to use the new port.

    C.Run thenet use Lpt3: \\PrtSrv\Printer02command.

    D.Run thenet print\\PrtSrv\Printer02command.

  • 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.

  • You are the administrator of Ezonexam's Windows 2000 network.

    You need to store secured files for Ezonexam's accounting and legal departments on a Windows 2000 Professional computer. You create two shared folders named Accounting and Legal with the default NTFS and share permissions. You also create two groups named Accounting and Legal and add the appropriate user accounts into the appropriate groups.

    To meet the security requirements for the shared folders the following criteria must be met:

    1. Users in both departments must be able to update their own files from the network.

    2. Users in the accounting department must be able to view the legal department's documents from the network.

    3. Users in the legal department must be prevented from being able to view the accounting department's documents from the network.

    You want to ensure that all security requirements are met using the least amount of administrative effort.

    What should you do?

    A.Allow the Accounting groupReadpermission on the Accounting share and the Legal shared folder. Allow the Legal groupReadpermissions on the Legal shared folder.

    B.Allow the Accounting groupFull Controlpermissions on the Accounting shared folder and the Legal shared folder. Allow the Legal groupFull Controlpermission on the Legal shared folder.

    C.Deny the Everyone groupFull Controlpermissions on the Accounting shared folder.

    D.Deny the Legal groupFull Controlpermission on the Accounting shared folder.