首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
49
问题
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
[A]Thefirststepinpreparingamarketingplanisthatofproducingtheinformationnecessaryfordecision-making.Usually,a
School-agechildrenshouldparticipatein60minutesormoreofmoderatetovigorousphysicalactivitydaily,accordingtoanex
Thisweekandnext,governments,internationalagenciesandnongovernmentalorganizationsaregatheringinMexicoCityattheWo
AlmosteveryyearsincetheendofthefinancialcrisishasstartedwithrosyexpectationsamongAmericanforecasters,andthis
"Thisisareallyexcitingtime—aneweraisstarting,"saysPeterBazalgette,thechiefcreativeofficerofEndemol,thetelev
MireilleGuiliano,achampagnecompanyexecutive,capturedtheattentionoffrustrateddieterswithherjoyoflifeinthe2005
Evenintraditionaloffices,"thelinguafrancaofcorporateAmericahasgottenmuchmoreemotionalandmuchmoreright-brained
GivingmillionsofexistingPayPalcustomerstheabilitytobuyattheclickofabuttonhasenormouspotentialforincreasing
Asthelatestcropofstudentspentheirundergraduateapplicationformandweighuptheiroptions,itmaybeworthconsidering
随机试题
A—cashbusinessJ—modeofpaymentB—commissionreceivablesK—downpaymentC—loanextensionL—re
下列腧穴中,治疗急性胃病应首选()
案情:甲乙共谋教训其共同的仇人丙。由于乙对丙有夺妻之恨,暗藏杀丙之心,但未将此意告诉甲。某日,甲、乙二人共同去丙处。为确保万无一失,甲、乙以人室盗窃为由邀请不知情的丁在楼下望风。进入丙的房间后,甲、乙同时对丙拳打脚踢,致丙受伤死亡。甲、乙二人旋即逃离现场。
下列各项中,应当作为以现金结算的股份支付进行会计处理的是()。
影响企业经营管理人员需求的参数有()。
在面向对象分析过程中,用概念模型来详细描述系统的问题域,用(5)来表示概念模型。(6)关系用于表示类与类、接口与接口之间的继承关系;在Java中,用(7)关键字来直接表示这种关系。
3下列程序中的循环体将会被执行()。publicclassex26{publicstaticvoidmain(String[]args){
在Access数据库中使用向导创建查询,其数据可以来自()。
RegistrationofforeignnationalsatthehealthcentrestandardproceduresRegisterasa(n)【L1】___________________.Filliname
Thesunroseuponatranquilworld,andbeameddownuponthepeacefulvillagelikeabenediction.Breakfastover,AuntPollyhad
最新回复
(
0
)