首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
14
问题
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
Writeanessayof160-200wordsbasedonthefollowingtable.Youressayshould1.describethechangesintheaveragefamilyex
Directions:Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressy
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
LastThursday,theFrenchSenatepassedadigitalservicestax,whichwouldimposeanentirelynewtaxonlargemultinationalst
Notlongago,chiefexecutiveofficers(CEOS)werelandedasheroes,leadersofthebraveneweconomy.BillGatesandJackWelchw
在用户管理组administrators中添加本地用户“sy”。
随机试题
思达集团原是一家房地产企业。2016年,思达集团以银行贷款为主要资金来源,开始大举并购一些发达国家的酒店和娱乐、体育健身等方面的业务。最近,思达集团由于收购规模过大,资金出现短缺。同时银行收紧了银根,不再向思达集团发放贷款。因此,思达集团被迫中止了收购活动
患者,女,30岁。尿频、尿痛2天。检查:体温38℃,右肾区叩击痛,尿蛋白(±),尿中红细胞2~4/HP,白细胞20~30/HP。应首先考虑的是( )。
A.氯苯那敏和泼尼松B.链霉素或异烟肼C.抗生素或磺胺类药物D.酮康唑和口泰E.阿昔洛韦及干扰素或转移因子治疗抗生素性口炎可选用的药物是
各种原始凭证,除由经办业务的有关部门审核以外,最后都要由()进行审核。
预算会计恒等式为“预算收入-预算支出=预算结余”,单位预算会计采用收付实现制。()
下列关于上市公司收购人权利义务的表述中,不符合上市公司收购法律制度规定的是()。(2013年)
设α1=(1,1,1,3)T,α2=(-1,-3,5,1)T,α3=(3,2,-1,P+2)T,α4=(-2,-6,10,p)T.P为什么数时,α1,α2,α3,α4线性相关?此时求r(α1,α2,α3,α4)和写出一个最大无关组.
网络管理协议中,简单网络管理协议SNMP是(1)协议,它基于(2)协议来传输数据。SNMP提供了4类管理操作,其中(3)操作用来提取特定的网络管理信息。SNMP是通过(4)方式实现管理功能的。在SNMP管理控制框架中定义了管理进程和管理代理,其中网络管理工
DriedFoodsCenturiesago,mandiscoveredthatremovingmoisture(51)foodhelpedtopreserveit,andthattheeasiestwaytod
Inoldday’s,whenaglimpseofstockingwaslookeduponassomethingfartooshockingtodistracttheseriousworkofanoffic
最新回复
(
0
)