首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
11
问题
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
微软认证
相关试题推荐
[A]Thefirststepinpreparingamarketingplanisthatofproducingtheinformationnecessaryfordecision-making.Usually,a
"3M"comesfrom"MinnesotaMining&Manufacturing,"butthosethreeMsmightbetterstandforMistake=Magic=Money.Throughoutit
Directions:Writeanessaybasedonthedrawing.Inyourwriting,youshould1)describethedrawingbriefly,2)exp
Directions:Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressy
Afterbeinginvolvedinanaccident,youwerelookedafterbyanotherperson.Writealetterofthanks:1)mentioningwhath
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
MusicfanshaveoftenviewedMicrosoftassomethinglikeabadcoverband,onethatpumpedoutuninvitingfacsimilesofApple’s
Itwassupposedtobethenew-mediaelection.E-mail,blogging,socialnetworkingandtweetingwereexpectedtosurgeinimporta
对MSN常规选项进行设置,使登录到Windows时自动运行Messenger(R),联系人联机时显示通知,收到电子邮件时通知我。
在【安全中心】窗口中开启Windows自动更新,设置为每天9:00自动下载安装。
随机试题
GlobalMarketsHitbyFearsofGrowthSlowdownA)InvestorsareworriedaboutslowereconomicgrowthinChina,agloomierou
药师调剂处方时必须做到“四查十对”。四查是指()
患者,男,60岁。大便后突起右手无力,讲话不清,约1h后昏迷。体检:浅昏迷,瞳孔等大,血压29.3/14.6kPa,右侧肢体瘫痪,肌张力低,腱反射未引出,右侧巴氏征阳性。最可能的诊断是
某装置的烟气原始含尘浓度20000mg/m3,经两级除尘器除尘,效率分别为98%和90%,除尘后的烟气含尘浓度为()。
()是求取估价对象未来开发完后的价值,减去未来的正常开发成本、税费和利润等,以此估算估价对象的客观合理价格或价值的方法。
从所给的四个选项中,选择最合适的一个填入问号处,使之呈现一定的规律性()。
英语课程标准要求培养学生达到综合语言运用的能力,其中文化意识能力包含文化知识、文化理解和——意识与能力。
n维向量组α1,α2,…,αs(3≤s≤n)线性无关的充要条件是()
A、Theyhavecomparedanimalbehaviorswithhumans.B、Theyknewhowtoavoidearthquakes.C、Theytriedmanywaystodecreaseeart
A、BecausetheEarthisheavilypolluted.B、Becausenaturecannotrecycleitsresources.C、Becausetherearemoreandmorepeople
最新回复
(
0
)