2. 计算机
  3. You are the administrator of a SQL Server 2000 computer. The server contains a database named Accounting. The data files are con

You are the administrator of a SQL Server 2000 computer. The server contains a database named Accounting. The data files are con

admin2009-05-19  27
问题 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.


The database has grown to 7 GB. The server has no more available disk space. You need to make more disk space available in the accounting database without affecting system performance.
What should you do?
选项 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.
转载请注明原文地址:https://kaotiyun.com/show/ouhZ777K
本试题收录于： 微软70228题库微软认证分类
0

微软70228

微软认证

相关试题推荐
随机试题
最新回复(0)