首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
40
问题
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
微软认证
相关试题推荐
MusicalTrainingCanImproveCommunicationSkillsAmericanscientistssaymusicaltrainingseemstoimprovecommunicationsk
Itneverrainsbutitpours.Justasbossesandboardshadfinallysortedouttheirworstaccountingandcompliancetroubles,an
Thenewaircraftrepresentsa$250mbetbyBombardierthatMexicocouldprovidenotjustroutinelabourbutmanufacturingthat
Writeanotepaperaccordingtothesituationbelow:Youareplanningtoinviteaforeignfriendtohavedinnertocelebrate
Youarethepresidentofacompany.WriteamemotoSallyCooper,theHRmanagerontheemployeestrainingoncomputerto,1
MireilleGuiliano,achampagnecompanyexecutive,capturedtheattentionoffrustrateddieterswithherjoyoflifeinthe2005
Insectsaredisappearing.Theworldhas25percentfewerterrestrialinsectsnowthanin1990.Thisincludesthosewerelyon
设置本地连启动WindowsXP系统自带防火墙。
在【安全中心】窗口中,设置windows防火墙,允许“文件和打印机共享”。
Thefollowingscenariowillbeusedforquestions29and30.Johnisanetworkadministratorandhasbeentoldbyoneofhisnet
随机试题
某地连降大雨,2001年8月1日大坝决堤,张某在洪水中失踪,一直生不见人,死不见尸。以下说法正确的是:
血管紧张素转化酶抑制药卡托普利降压作用不包括
患者王某,身高180cm,体重80kg,因急性阑尾炎合并穿孔,急诊在硬膜外麻醉下行阑尾切除术。采取此种体位的目的是
大风、大雨后,应检查支架、脚手架、起重设备、临时用电工程、临时房屋等设施的基础。()
下列关于设备寿命的叙述,正确的有()。
根据《中华人民共和国会计法》的规定,行使会计工作管理职能的政府部门是()。
(2011广东商学院)投保单
如果内存变量和字段变量均有变量名"姓名",那么引用内存变量错误的方法是( )。
InordertorentanddriveacarinJapan,yourequireaJapanesedrivinglicenseoraninternationaldrivingpermit.Incaseof
A、Manaltershisenvironmentwhileheisadapted.B、Manisonlyadaptedtotheenvironmentbuthedoesn’talterit.C、Otherlivi
最新回复
(
0
)