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

admin2009-05-19 27

问题 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://kaotiyun.com/show/AuhZ777K

本试题收录于：微软70228题库微软认证分类

微软70228

微软认证

相关试题推荐

随机试题

最新回复(0)

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

微软70228

微软认证

Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an

Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby

School-agechildrenshouldparticipatein60minutesormoreofmoderatetovigorousphysicalactivitydaily,accordingtoanex

Supposeyouarethepersonnelmanagerofacompanyandyou’vedecidedtheapplicantnamedZhangWeiisthebestcandidateforth

EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based

In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But

In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But

In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But

MenorcaorMajorca?Itisthattimeoftheyearagain.Thebrochuresarepilingupintravelagentswhilenewspapersandmagazin

某加速度计具有如下的参数：m＝0．01kg，k＝200N／m，χmax＝±0．2cm，则其可测量的最大加速度为【】

联营企业、中外合资或者合作企业的联营、合资、合作各方，认为联营、合资、合作企业权益或者自己一方权益受具体行政行为侵害的，可以谁的名义提起诉讼()

下列选项中属于商品的有()

患者，男性，47岁，右上后牙固定义齿修复半年后松动。查：缺失，余牙正常，全冠固定桥，固位体松动。拆除固定桥后发现，预备体聚合度过大，轴面浅龋。重新修复时应

甲将一个古董出售给乙，并约定两个月后交付。丙知道甲出售古董后，愿出比乙更高的价格购买。甲便将该物卖给丙，并当场交付该物与丙，但丙未付款。在此种情况下，下列判断哪些是正确的?

用高级语言编写的源程序，将其转化成能在计算机上运行的程序过程是()。

下列关于项目评价中流动资金及其估算方法的说法，正确的是()。

根据《中华人民共和国公司法》的规定，股东会行使的职权有()。Ⅰ．修改公司章程Ⅱ．决定公司的经营方针和投资计划Ⅲ．审议批准董事会的报告Ⅳ．对发行公司债券作出决议

技术环境对战略所产生的影响包括()。