首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
46
问题
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
微软认证
相关试题推荐
In2009theEuropeanCommissioncarriedoutaninvestigationintoMicrosoft.TheAmericansoftwaregianttiedInternetExplorer,
[A]Thefirststepinpreparingamarketingplanisthatofproducingtheinformationnecessaryfordecision-making.Usually,a
Itishardtomakemoneypeddlingsocialmediaanywhere.Duringtheirfirstfewyearsinbusiness,FacebookandTwitterlostpo
[A]Butworkisunderwaytogetcomputerstocapturehumanlifeandrememberitaspeopledo—recallingbitsofexperiencethata
[A]Enduringproblemssuchaswar,poverty,andviolenceultimatelyspringfromhumannature,whichnotechnologicalinnovation
[A]Enduringproblemssuchaswar,poverty,andviolenceultimatelyspringfromhumannature,whichnotechnologicalinnovation
TheBestMediatoUseThereareplentyofoptionsavailableforspreadingnews,suchasnewspapers,radio,TV,theInternet
Whethertheeyesare"thewindowsofthesoul"isdebatable;thattheyareintenselyimportantininterpersonalcommunicationis
DrRichardBergland,abrainresearcherattheHarvardMedicalSchool,haswrittenapapersuggestingthathumanbrainisbasica
通过【网上邻居】查找网上计算机和共享文件资源,IP为“202.204.54.23”,主机名为administrator,共享文件夹名为“tools”。
随机试题
若将I=∫1edx∫0lnxf(x,y)dy改变积分顺序,则I=___________.
直肠肛管交界的齿线在临床上的重要性体现在
何某依法院生效判决向法院申请执行甲的财产,在执行过程中,甲突发疾病猝死。法院询问甲的继承人是否继承遗产,甲的继承人乙表示继承,其他继承人均表示放弃继承。关于该案执行程序,下列哪一选项是正确的?
用锤击沉桩时,为了防止桩受冲击应力过大而损坏.其锤击方式应是:
已知三个非零向量a、b、c中任意两向量都不平行,但a+b与c平行,b+c与a平行,则a+b+c=( )。
下列关于消防电梯的设置要求叙述错误的是()。
下列说法正确的是()。(2012年真题题库)
决策树适合下列哪种类型的决策()。
有人说:孤独是蚌病成珠。忍耐痛苦的结果是得到那颗美丽绝伦的珍珠,相反,乐于独处的人把独处看成是难得的享受。独处,最有利于想象力的发挥。独对自然,心灵会像宇宙一样深邃;独观书籍,思想会像电波一样通达古今;独赏音乐,情绪会像雪莲一样玉洁冰清;独坐静思,自我会像
某信息处理项目的计划进度曲线如下图(以时间为横轴,已完成任务的比例为纵轴)。设A点是项目中期检查实际到达之处(位于计划进度曲线的左侧),则检查的结论是_________。
最新回复
(
0
)