2. 计算机
  3. You are the administrator of a SQL Server 2000 computer. The server contains a database named MedicalRecords. You have recently

You are the administrator of a SQL Server 2000 computer. The server contains a database named MedicalRecords. You have recently

admin2009-05-19  38
问题 You are the administrator of a SQL Server 2000 computer. The server contains a database named MedicalRecords. You have recently added a hard disk to the server and configured the database.
The data files are configured as shown in the Database Properties exhibit.


The database is configured as shown in the Database Schema exhibit.


Each primary key is clustered. All foreign keys contain nonclustered indexes. You want to use the space on the new hard disk to make the database respond more quickly to queries.
What should you do?
选项 A、Re-create the Notes table on the SECONDARY filegroup.
B、Re-create the nonclustered indexes on the SECONDARY filegroup.
C、Re-create the Patients and Doctors tables and their indexes on the SECONDARY filegroup.
D、Re-create the Cases and Notes tables and their indexes on the SECONDARY filegroup.
答案B
解析 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:
A, C, D: With SQL Server 2000, placing the tables and their nonclustered indexes in different filegroups that are located on different physical drives provides better performance than placing tables in different filegroups and on different physical drives.
转载请注明原文地址:https://www.kaotiyun.com/show/AuhZ777K
本试题收录于： 微软70228题库微软认证分类
0

微软70228

微软认证

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