首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
35
问题
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
微软认证
相关试题推荐
[A]Thefirststepinpreparingamarketingplanisthatofproducingtheinformationnecessaryfordecision-making.Usually,a
School-agechildrenshouldparticipatein60minutesormoreofmoderatetovigorousphysicalactivitydaily,accordingtoanex
Imaginativeworkssuchasnovels,plays,films,fairytales,andlegendspresentamoreaccurateandmeaningfulpictureofhuman
[A]"Ijustdon’tknowhowtomotivatethemtodoabetterjob.We’reinabudgetcrunchandIhaveabsolutelynofinancialrewa
Fewthingssay"forgetI’mhere"quitesoeloquentlyastheposeoftheshy—theavertedgaze,thehunchedshoulders,thebodypi
Fewthingssay"forgetI’mhere"quitesoeloquentlyastheposeoftheshy—theavertedgaze,thehunchedshoulders,thebodypi
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
TheU.S.PostalService(USPS)continuestobleedredink.Itreportedanetlossof$5.6billionforfiscal2016,the10thst
Evenintraditionaloffices,"thelinguafrancaofcorporateAmericahasgottenmuchmoreemotionalandmuchmoreright-brained
随机试题
直流供电型火灾显示盘通常采用()。
以下哪部是陈映真的作品?()
如血象显示全血细胞减少,骨髓象显示增生低下,三系造血均减低,则符合
术后早期活动的好处有
在项目卖点挖掘完成之后,企业应将其加以提炼,形成具体的(),以便在广告推广中加以运用。
市场预测方法中的简单移动平均法一般适用于()。
张某,男性,19岁,高中文化。 自我陈述:因反复做事,犹豫不决,自知不必想或不必做的事仍要想、要做,为之痛苦紧张3年。求助者15岁开始遗精,由偶然渐至频繁,多达每日数次,有时手淫。对此事不敢声张,暗中自责。16岁考入高中,因学习日渐紧张,对担任学生干部
子语言
数学式y2>x>=10在VB中应表示为
A、IncentralLondon.B、Nearapolicestation.C、Bythetubestation.D、Onasidestreet.CWheredidsheparkhercar?
最新回复
(
0
)