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

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

×
驗證
广西快乐双彩开奖30期