首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of a SQL server 2000 computer that contains a database named Acct. The database contains 1.5 GB of dat
You are the administrator of a SQL server 2000 computer that contains a database named Acct. The database contains 1.5 GB of dat
admin
2009-05-19
45
问题
You are the administrator of a SQL server 2000 computer that contains a database named Acct. The database contains 1.5 GB of data. The server has one 9-GB hard disk that is configured as shown in the Exhibit.
You need to import data into the database without adversely affecting database performance. The data will require an additional 2GB of storage space.
What should you do?
选项
A、Add another data file on drive E, and then add the file to the PRIMARY filegroup.
B、Move the transaction log file to drive E, and set the file growth of Acc_Data.mdf by selecting the Unrestricted file growth option.
C、Rebuild all clustered indexes so that they have a fill factor of 100.
D、Compress drive D.
答案
A
解析
Explanation: We must take precautions so that the import process of 2 GB data will run. We add a new file to drive E, which has 3 GB free disk space. By placing the new file in the primary file group we ensure that new data added to the database will be added to new data file. The primary file group is the default file group and new data is automatically added to it.
Incorrect Answers:
B: Moving the transaction log from Drive D to Drive would free up 800MB. This would leave 1.3GB of free disk space on drive D. But the import process will require another 2GB so we will not have enough free disk space.
C: Rebuilding the clustered indexes with a fill factor of 100 makes that the index pages full. This would degrade performance during the import process due to page splits.
D: Compressing a partition which is used by SQL Server is not a good idea. It would, if at all possible, degrade performance.
转载请注明原文地址:https://kaotiyun.com/show/BrhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
Writealettertoamuseum’sstafftoaskforsomeinformationaboutahistoricalexhibition.Youshouldincludethedetailsyou
Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressyourownopinion.
Writeanessaybasedonthechart.Inyourwriting,youshould1)describethediagram,and2)giveyourcomments.Y
Theideaisasaudaciousasitaltruistic:provideapersonallaptopcomputertoeveryschoolchild—particularlyinthepoorestp
"Thisisareallyexcitingtime—aneweraisstarting,"saysPeterBazalgette,thechiefcreativeofficerofEndemol,thetelev
Whethertheeyesare"thewindowsofthesoul"isdebatable;thattheyareintenselyimportantininterpersonalcommunicationis
MusicfanshaveoftenviewedMicrosoftassomethinglikeabadcoverband,onethatpumpedoutuninvitingfacsimilesofApple’s
UsingFacebookmakespeoplesadder,atleastaccordingtosomeresearch.Burjustwhatisitaboutthesocialnetworkthattakes
UsingFacebookmakespeoplesadder,atleastaccordingtosomeresearch.Burjustwhatisitaboutthesocialnetworkthattakes
Thefollowingscenariowillbeusedforquestions29and30.Johnisanetworkadministratorandhasbeentoldbyoneofhisnet
随机试题
应首先考虑何诊断为诊断该患者有无乳酸酸中毒,下列哪项最有意义
A.急诊处方 B.儿科处方 C.麻醉药品处方 D.第一类精神药品处方 E.第二类精神药品处方处方笺为淡黄的是
在“银行存款余额调节表”中,经过未达账项调整后的企业银行存款日记账余额和银行对账单余额一定是一致的。()
金苑科技公司会计小丽因工作努力,积极提出合理化建议,多次被公司评为先进会计工作者。小丽的男友在一家民营科技公司任总经理,在其男友的多次请求下,小丽将在工作中接触到的公司新产品研发计划及相关会计资料复印件提供给其男友,给公司带来一定的损失,公司认为小丽不宜继
某机械厂生产某种型号零件需经三道工序制成,在产品成本的计算采用“约当产量法”。某月份投产500件(原材料在生产开始时一次性投入),完工产品400件,企业月末账面在产品成本为1000元,其他有关财务资料见表9-1和表9-2(计算按每步骤保留小数点后两位)。
2019年2月1日某企业购入原材料一批,开出一张面值为116000元,期限为3个月的不带息的商业承兑汇票。2019年5月1日该企业无力支付票款时,下列会计处理正确的是()。
下图是谁的书法作品?()
某市劳动就业管理局为了加强对城镇就业失业人员的实名管理,进一步做好劳动者的就业工作,经人民政府同意,决定对全市城镇就业人员统一进行登记发放就业登记证,为此,行文告知全市各级劳动管理部门及有关单位。根据以上案例。回答以下问题:行文的主送机关是()。
根据所给资料,回答问题。2012年上半年,全国汽车商品进出口总额为774.86亿美元,同比增长18.76%。其中,进口金额416.12亿美元,同比增长20.46%;出口金额358.74亿美元,同比增长16.86%。6月,全国汽车商品进出
•Readthetextabouttheimportanceofqualifications.•Inmostofthelines34—45thereisoneextraword.Oneortwolines,ho
最新回复
(
0
)