首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
44
问题
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
微软认证
相关试题推荐
Whenpeopletalkabouta"north-southdivide"inBritain,theyusuallyrefertohouseprices,employmentandtheratioofprivat
Menandwomendothinkdifferently,atleastwheretheanatomyofthebrainisconcerned,accordingtoanewstudy.Thebrainis
Thenewaircraftrepresentsa$250mbetbyBombardierthatMexicocouldprovidenotjustroutinelabourbutmanufacturingthat
TheChineseScienceandTechnologyPapersBeingIncludedinSCI收录的中国科技论文A.Studythechartscarefullyandwriteanessayof160
Writeanessaybasedonthechart.Inyourwriting,youshould1)describethediagram,and2)giveyourcomments.
Afterbeinginvolvedinanaccident,youwerelookedafterbyanotherperson.Writealetterofthanks:1)mentioningwhath
WhileAmericanshavebecomeevermoredependentuponelectricityintheirdailylives,acrucialpartofthesystemthatsupport
MusicfanshaveoftenviewedMicrosoftassomethinglikeabadcoverband,onethatpumpedoutuninvitingfacsimilesofApple’s
Parentsarenottheonlyonesresponsiblefortheirchildren.Oursocialresponsibilityisatitsgreatestwhenparentsareunab
Itwassupposedtobethenew-mediaelection.E-mail,blogging,socialnetworkingandtweetingwereexpectedtosurgeinimporta
随机试题
钾通道开放药作用叙述错误的是
男性,25岁,8个多月来肥胖,皮肤紫纹和痤疮,化验24h尿17-羟和尿17-酮明显增高,血ACTH增高,大剂量地塞米松抑制试验结果未被抑制。最可能的诊断是
一般二尖瓣瓣口面积小于多少时方有明显症状
(2015年第168题)呼吸系统肿瘤中,由神经内分泌细胞发生的包括
某地肺癌高发,经调查与当地人吸烟密切相关,必须进行干预。为制订中学生控烟计划,下列哪些因素需要考虑
治疗经间期出血湿热证,应首选
股票基金的管理费率为()。
()主要反映一国的贸易和劳务往来状况,包括贸易收支、劳务收支(如运输、旅游等)和单方面转移(如汇款、捐赠等),是最具综合性的对外贸易的指标。
曲:直
Itislikely____________(上级领导很可能会批准这个计划).
最新回复
(
0
)