单选题 You are the administrator of a SQL Server 2000 computer. The server contains a database named Accounting. The data files are configured as shown in the exhibit.

A、 Compress drive E.
B、 Add a new hard disk to the server. Create a new file on the new hard disk as part of the PRIMARY filegroup.
C、 Add a new hard disk to the server. Create a new file on the new hard disk as part of a new filegroup.
D、 Map a network drive to the server. Create a new data file on the network drive as part of the PRIMARY filegroup.
E、 Map a network drive on the server. Create a new data file on the network drive as part of a new filegroup.

【正确答案】 B

【答案解析】解析：Explanation: When a SQL Server 2000 server runs out of disk space, additional hard drives must be added to the server. A file can then be created on the new disk as part of an existing filegroup or as part of a new filegroup. In this scenario a new file should be placed on the new hard disk for best performance. This file can either be placed in the PRIMARY filegroup or a new filegroup could be created. The performance gain would be equal in both cases, but if we use a new filegroup we would have to configure it so that it would be used. Incorrect Answers: A: SQL Server data files cannot be installed on a system that uses compression. C: When a SQL Server 2000 server runs out of disk space, additional hard drives must be added to the server. A file can then be created on the new disk as part of an existing filegroup or as part of a new filegroup. To use the new filegroup we would have to configure it (add data to it or make it the default filegroup). Without configuration the new filegroup will not be used. All data would still be added to the default PRIMARY filegroup. D: Mapping a network drive to the server will increase the disk space available to the database but query time will be limited to the network environment and network transfer speeds. This will hamper query response time. E: Mapping a network drive to the server will increase the disk space available to the database but query time will be limited to the network environment and network transfer speeds. This will hamper query response time.