首页 >计算机类 >微软认证 > >You are the administrator of a 12 SQL Server 2000 computers. These servers are located in company offices throughout the world.

You are the administrator of a 12 SQL Server 2000 computers. These servers are located in company offices throughout the world.

时间:2019-11-01 05:56浏览次数:

You configure a multiserver job on the server in your company's New York City office. You configure this server as a master server, and designate the remaining 11 servers as target servers.

After the job completes successfully, you decide to set up a new SQL Server 2000 computer as the master server. The new server will be named JobMaster and the other 12 servers will be target servers.

You need to make the New York City server a target server instead of a master server. What should you do?

A.On the New York City server, defect all 11 target servers. On the JobMaster server, enlist the 12 servers as target servers.

B.On the JobMaster server, enlist all other servers as target servers.

C.On the New York City server enlist the JobMaster server as a target server. Transfer the multiserver jobs from the New York City server to the JobMaster server.

D.On the JobMaster server, enlist the New York City server as a target server. On the JobMaster server, enlist the other 11 servers as target servers. On the JobMaster server, defect the New York City server.

参考答案

正确答案:A
解析:Explanation:Whensettingupanewmasterserver,theoldmasterservermustdefectallitstargetservers.Whenanewlydesignatedmasterserverreplacesanexistingmasterserver,thetargetserversmustbedefectedfromtheexistingmasterserver.Thetargetserverscanthenbeenlistedonthenewmasterserver.Thiscanincludetheexistingtargetserver.Note:InSQLServer2000EnterpriseEdition,multiserveradministrationisusedtoautomatetheadministrationofmultipleinstancesofSQLServer2000.Itcanbeusedtomanagetwoormoreserversandtoscheduleinformationflowsbetweenenterpriseserversfordatawarehousing.Withmultiserveradministration,theremustbeatleastonemasterserverandatleastonetargetserver.Amasterserverdistributesjobstoandreceiveseventsfromtargetservers.Amasterserverstoresthecentralcopyofjobdefinitionsforjobsrunontargetservers.Targetserversconnectperiodicallytotheirmasterservertoupdatetheirlistofjobstoperform.Ifanewjobexists,thetargetserverdownloadsthejobanddisconnectsfromthemasterserver.Afterthetargetservercompletesthejob,itreconnectstothemasterserverandreportsthestatusofthejob.WithSQLServer2000EnterpriseEdition,masterserverscanenlisttargetserversandcandefecttargetservers.IncorrectAnswers:B:ThissolutiondoesnotaddresstheneedtodemotetheNewYorkCityserver.Itisthusstillamasterserver.C:InthissolutiontheJobMasterserverisenlistedasatargetserveroftheNewYorkCityserver.ThissolutionalsodoesnotaddresstheneedtodemotetheNewYorkCityserver.Itisthusstillamasterserver.D:InthissolutiontheNewYorkCityserverisnotatargetserveroftheJobMasterserverasithasbeendefectedfromtheJobMasterserver.

    阅读排行