2. 计算机
  3. You are the administrator of a SQL Server 2000 computer. The server contains a database that is heavily indexed and that company

You are the administrator of a SQL Server 2000 computer. The server contains a database that is heavily indexed and that company

admin2009-05-19  60
问题 You are the administrator of a SQL Server 2000 computer. The server contains a database that is heavily indexed and that company users query extensively. The database has grown and query response time has slowed. The database is stored in a single data file.
You want to accelerate query response time. What should you do?
选项 A、On a new hard disk, create a new filegroup. Drop the existing nonclustered indexes, and then re-create them on the new filegroup.
B、On a new hard disk, add a new file to the PRIMARY filegroup. Drop the existing nonclustered indexes, and then re-create them on the PRIMARY filegroup.
C、On the existing hard disk, create a new filegroup. Drop the existing nonclustered indexes, and then re-create them on the new filegroup.
D、On the existing hard disk, add a new file to the primary filegroup. Drop the existing nonclustered indexes, and then re-create them on the PRIMARY filegroup.
答案A
解析 Explanation: 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 heavily accessed 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.

Incorrect Answers:
B: SQL Server 2000 can operate effectively without filegroups. In this case, all files are included in the primary filegroup and SQL Server 2000 can allocate data anywhere in the database. Furthermore, filegroups are not the only method that can be used to distribute I/O across multiple drives. However, the nonclustered index is added to the filegroup rather than the new file in this solution. This is thus not the best solution.

C: This solution does not take advantage of the possible performance gains that can be realized by placing data tables and indexes on separate physical disks.

D: This solution does not take advantage of the possible performance gains that can be realized by placing data tables and indexes on separate physical disks. This would require that a new file group be created.
转载请注明原文地址:https://www.kaotiyun.com/show/1uhZ777K
本试题收录于： 微软70228题库微软认证分类
0

微软70228

微软认证

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