首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of a SQL Server 2000 computer. The server contains a database named Sales. The database will store sal
You are the administrator of a SQL Server 2000 computer. The server contains a database named Sales. The database will store sal
admin
2009-05-19
37
问题
You are the administrator of a SQL Server 2000 computer. The server contains a database named Sales. The database will store sales transactions. Retail locations must be able to add transactions to the database 24 hours a day every day. The server is configured as shown in the exhibit.
You need to configure the data files and transaction log for the Sales database. What should you do?
选项
A、Place the transaction log on physical disk 0 and the data file on the RAID-5 disk array.
B、Place the transaction log on the RAID-5 disk array and the data file on physical disk 0.
C、Place the transaction log and the data file on physical disk 0.
D、Place the transaction log and the data file on the RAID-5 disk array.
答案
D
解析
Explanation: Because retail locations must be able to add transactions to the database 24 hours a day every day, we must minimize any possible downtime and ensure that the server has high availability. Using a hardware-based RAID-5 disk array, we would increase availability as RAID-5 provides redundancy of all data on the array, allowing a single disk to fail and be replaced in most cases without system downtime.
Incorrect Answers:
A: By placing the transaction log on physical disk 0 we will not take advantage of the fault tolerance made possible by the RAID-5 disk array. The transaction log is thus not fault tolerant in this solution.
B: By placing the data file on physical disk 0 we will not take advantage of the fault tolerance made possible by the RAID-5 disk array. The data file is thus not fault tolerant in this solution.
C: By placing the transaction log and the data file on physical disk 0 we will not take advantage of the fault tolerance made possible by the RAID-5 disk array. In this solution the database is not fault tolerant and a disk failure would result in unnecessary downtime.
转载请注明原文地址:https://kaotiyun.com/show/juhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
[A]"Ijustdon’tknowhowtomotivatethemtodoabetterjob.We’reinabudgetcrunchandIhaveabsolutelynofinancialrewa
Directions:Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressy
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
LastThursday,theFrenchSenatepassedadigitalservicestax,whichwouldimposeanentirelynewtaxonlargemultinationalst
Itstartedsmall.Justapoliticalslogan,pastedontoaposterinabackofficesomewhere;NOEUROin1999.Germany’smainoppo
TheU.S.PostalService(USPS)continuestobleedredink.Itreportedanetlossof$5.6billionforfiscal2016,the10thst
Evenintraditionaloffices,"thelinguafrancaofcorporateAmericahasgottenmuchmoreemotionalandmuchmoreright-brained
Whateverhappenedtothedeathofnewspaper?Ayearagotheendseemednear.Therecessionthreatenedtoremovetheadvertising
随机试题
与市场营销学相关的学科包括()
下列各项中,会引起无形资产账面价值发生增减变动的有()。
西周时天子要在太庙举行策命礼,向诸侯授“策”。这反映当时实行的制度是()。
“用最严谨的标准、最严格的监管、最严厉的处罚、最严肃的问题,确保广大人民群众‘舌尖上的安全’。”不久前闭幕的中央农村工作会议,把食品安全放在更加重要的位置来谋划,四个“最”________,一个“确保”________。这样的宣示与承诺,对农产品生产提出了
操作系统是计算机系统中的
A、Toattractmoreseaanimalstothetestingsite.B、Todrivedangerousseaanimalsawayfromthetestingsite.C、Tohelptrack
A、Hewasfined.B、Heboughtaticket.C、Hetaughtalesson.D、Hehadanaccident.A
A、He’splayingsports.B、He’swatchingsportsgames.C、He’sdriving.D、He’sfighting.CW:Heavens!Pleasebecareful.Youalmost
TeainBritainTea,thatmostessentialEnglishdrinks,isarelativelatecomertoBritishshores.Althoughthecustomofd
Stock,inbusinessandfinance,isashareofownershipinacorporation.Sharesinacorporationcanbeboughtandsold,usuall
最新回复
(
0
)