首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
58
问题
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]Thefirststepinpreparingamarketingplanisthatofproducingtheinformationnecessaryfordecision-making.Usually,a
Fewthingssay"forgetI’mhere"quitesoeloquentlyastheposeoftheshy—theavertedgaze,thehunchedshoulders,thebodypi
WhentheresidentsofBuenosAireswanttochangethepesostheydonottrustintothedollarstheydo,theygotoacueva,or"
Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressyourownopinion.
OfferingHelpWritealetterofabout100wordsbasedonthefollowingsituation:YourroommateKenismovingtoanother
Supposeyouhavefoundsomethingwrongwiththebookthatyouboughtfromanonlinestoretheotherday.Writeane-mailtothe
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
MenorcaorMajorca?Itisthattimeoftheyearagain.Thebrochuresarepilingupintravelagentswhilenewspapersandmagazin
LastThursday,theFrenchSenatepassedadigitalservicestax,whichwouldimposeanentirelynewtaxonlargemultinationalst
Americanfarmershavebeencomplainingoflaborshortagesforseveralyearsnow.Givenamulti-yeardeclineinillegalimmigrati
随机试题
《聊斋志异》的文体类型是()
进餐后上腹痛,左侧卧位可缓解,可见于()
现场行政处罚决定书应当载明
疮疡三陷证中.火陷证的治法是
有关10kV变电所对建筑的要求,下列哪一项是正确的?()
下列四种情形中,适宜采用固定总价合同的工程是()。
下列合同中,属于单务合同的是()。
【2015年菏泽市真题】人们经常借助于外在的具体形式,如画图表、路线图等表征问题,这是()的过程。
体内不产生P450物质的人与产生P450物质的人比较,前者患帕金森氏综合症(一种影响脑部的疾病)的可能性三倍于后者。因为P450物质可保护脑部组织不受有毒化学物质的侵害。因此,有毒化学物质可能导致帕金森氏综合症。下列哪项,如果为真,将最有力地支持以上论证?
设函数f(x)满足关系式f(t-1)dt=x4/,求f’(x).
最新回复
(
0
)