首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
admin
2009-05-19
61
问题
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://kaotiyun.com/show/1uhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
[A]Marketforglasscraftsisgrowing[B]Dependenceofcomputerdevelopmentonglass[C]Behindtheadaptabilityofglass[D]
[A]Enduringproblemssuchaswar,poverty,andviolenceultimatelyspringfromhumannature,whichnotechnologicalinnovation
CigarettesmokingisahealthhazardofsufficientimportanceintheUnitedStatestowarrantappropriateremedialaction.Itwa
AlmosteveryyearsincetheendofthefinancialcrisishasstartedwithrosyexpectationsamongAmericanforecasters,andthis
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
MireilleGuiliano,achampagnecompanyexecutive,capturedtheattentionoffrustrateddieterswithherjoyoflifeinthe2005
InToday’smanagement-theoryindustry,reputation—oratleastthecorporatekind—isa"strategicasset"thatcanbe"leveraged"
Google,whichdominatesmuchoflifeontheInternet,hasbeentryingtoexpandbeyondcomputersandtelephonestolivingrooms,
GivingmillionsofexistingPayPalcustomerstheabilitytobuyattheclickofabuttonhasenormouspotentialforincreasing
设置网络打印机,不允许每个连接到该计算机的用户都使用该网络打印机,只允许用户Administrators和Powerusers使用本地打印机。
随机试题
在香港、澳门未回归祖国前,香港、澳门问题的是实质是()
Rh阴性的母亲所生的Rh阳性子女,有可能患
快速进展型牙周炎的主要致病菌,除外
在按份之债中()。
产业结构就其基本内容来看包括三个方面()。
对一含标题行的工作表进行排序,当在【排序】对话框中的【当前数据清单】框中选择【没有标题行】选项按钮时,该标题行()。
因违法被吊销会计从业资格证的人员,自被吊销之日起()年内不得参加会计从业资格考试,不得重新取得会计从业资格证书。
在生产和经济活动中,安全也可以看成是________处于协调、平衡的状态,一旦打破这种平衡,安全就不存在了。
最早提出归因理论的是美国心理学家()。
人生如棋,棋子犹如角色转换的定位,每一枚棋子都有属于自己的位置。平时,我们总是偏爱车、马、炮等杀伤力强的“强盗”,而轻视兵卒之类的弱子。其实,最终直捣黄龙、克敌制胜的,却往往可能是一个毫不起眼的小卒。同样,人们在社会生活中扮演着不同的角色,每个人的角色只有
最新回复
(
0
)