首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of two Microsoft Windows 2000 advanced server computers. On these servers, you are configuring a datab
You are the administrator of two Microsoft Windows 2000 advanced server computers. On these servers, you are configuring a datab
admin
2009-05-19
41
问题
You are the administrator of two Microsoft Windows 2000 advanced server computers. On these servers, you are configuring a database that will store accounting information for your company.
The data must be available at all times. Interruptions in data connectivity should not last longer than five minutes. Any changes to the database should not require you to reconfigure the client computers.
How should you configure the database?
选项
A、Configure the database on the two servers as a SQL Server 2000 cluster.
B、Configure the database on one server, and then configure a standby database on the second server.
C、Configure the database on each server. Use Microsoft Distributed Transaction Coordinator to keep the two servers perfectly synchronized.
D、Configure the database as a federated database, and then partition half the data on each server.
答案
A
解析
Explanation: SQL Server 2000 failover clustering provides high availability support by allowing us to configure one failover cluster to automatically, with no manual configuration, fail over to any other node in the failover cluster configuration. In this way, we minimize system downtime and provide high server availability during an operating system failure or a planned upgrade. Before SQL Server 2000 failover clustering can be set up, we must install Windows NT 4.0, Enterprise Edition, Windows 2000 Advanced Server or Windows 2000 Datacenter Server, and the Microsoft Cluster Service (MSCS).
In this scenario a cluster would be preferred to a standby server because it would be available immediately. A standby server on the other would require manual configuration and more time to become online.
Incorrect Answers:
B: A standby server would require you to reconfigure clients to allow it to connect to the standby server when the main server goes down. It would require at least several minutes of manual administration before the standby server would be operational. But the scenario requires that no reconfiguration of the client computers should be necessary. Therefore we should use a SQL Server 2000 cluster not a standby server.
Note: A standby server is a second server that contains a copy of the databases on the primary server and that can be brought online in the event of a primary server failure or due to scheduled maintenance on the primary server. This allows users to continue working with databases when the primary server becomes unavailable. When the primary server becomes available again, any changes to the standby server’s copies of databases must be restored back to the primary server.
C: The Microsoft Distributed Transaction Coordinator coordinates distributed transactions, but would not increase availability.
Note: The Microsoft Distributed Transaction Coordinator (MS DTC) is a transaction manager that allows client applications to include several different sources of data in one transaction. MS DTC coordinates committing the distributed transaction across all the servers enlisted in the transaction.
An installation of SQL Server 2000 can participate in a distributed transaction by calling stored procedures on remote servers running SQL Server, automatically or explicitly promoting the local transaction to a distributed transaction and enlist remote servers in the transaction, and making distributed updates that update data on multiple OLE DB data sources. If these OLE DB data sources support the OLE DB distributed transaction interface, SQL Server 2000 can also enlist them in the distributed transaction. The MS DTC service coordinates the proper completion of the distributed transaction to ensure that either all of the updates on all the servers are made permanent, or, in the case of errors, all erased.
D: With Federated SQL Server 2000 servers, SQL Server 2000 databases can be spread across a group of autonomous database servers. These are capable of supporting the processing growth requirements of the largest Web sites and enterprise data-processing systems built with Microsoft Windows DNA, which divides the processing units of a data processing system into logical tiers. This however does not improve availability.
转载请注明原文地址:https://kaotiyun.com/show/6rhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
Whenpeopletalkabouta"north-southdivide"inBritain,theyusuallyrefertohouseprices,employmentandtheratioofprivat
About3billionpeoplelivewithin100milesofthesea,anumberthatcoulddoubleinthenextdecadeashumansflocktocoasta
Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressyourownopinion.
Directions:Writeanessaybasedonthechart.Inyourwriting,youshould1)describethechart,and2)giveyourc
Despitethemountainsofinformationwarningusofthedangerofsmoking,teenagersmokingisontherise.Inthissection,you
Thepicturedepictsafunnysceneinthehospitalvividly.Severalpeoplearewaitinginquitealongqueueoutsidetheclinicw
YouhavejustcomebackfromUKasamemberofaSino-Britishculturalexchangeprogram.Writeane-mailtoyourBritishcolle
InParagraphs1and2,thetextshowsPTK’s______.Skepticalobserversbelievethatancestrytestingfailsto______.
BedwettingMillionsofkidsandteenagersfromeverypartoftheworldwetthebedeverysinglenight.It’ssocommonthatt
对MSN常规选项进行设置,使登录到Windows时自动运行Messenger(R),联系人联机时显示通知,收到电子邮件时通知我。
随机试题
税法的基本原则中,要求税法的制定要有利于资源的有效配置和经济体制的有效运行的原则是()。
明清时期,长江三角洲一带经济作物大发展,粮食多仰仗两湖一带,故有()
正确处理行政权力与行政责任之间关系的一个基本原则是()
口服降糖药磺酰脲类降血糖作用的主要机制是
2001年全国人大常委会作出解释:《刑法》第410条规定的“非法批准征用、占用土地”,是指非法批准征用、占用耕地、林地等农用地以及其他土地。对该法律解释,下列理解错误的是:()
军队实施国家统一的会计制度的具体办法由中国人民解放军总后勤部制定,报()备案。
Naturally,she______thatoncetherewasanewfilmeverybodywouldbeeagertogoandseeit.
“准”,就是要注意策略,讲究工作方法,不打无准备之仗,不打无把握之仗。要打得适时、有力,同时注意时间、地点、对象、节奏及宣传方法。( )
求y"+4y’+4y=eax的通解,其中a为常数;
在考生文件夹下打开文档WORD.DOCX。某高校学生会计划举办一场“大学生网络创业交流会”的活动,拟邀请部分专家和老师给在校学生进行演讲。因此,校学生会外联部需制作一批邀请函,并分别递送给相关的专家和老师。请按如下要求,完成邀请函的制作
最新回复
(
0
)