2. 计算机
  3. 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.

admin2009-05-19  29
问题 You are the administrator of a 12 SQL Server 2000 computers. These servers are located in company offices throughout the world.

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: When setting up a new master server, the old master server must defect all its target servers. When a newly designated master server replaces an existing master server, the target servers must be defected from the existing master server. The target servers can then be enlisted on the new master server. This can include the existing target server.

Note: In SQL Server 2000 Enterprise Edition, multiserver administration is used to automate the administration of multiple instances of SQL Server 2000. It can be used to manage two or more servers and to schedule information flows between enterprise servers for data warehousing. With multiserver administration, there must be at least one master server and at least one target server.

A master server distributes jobs to and receives events from target servers. A master server stores the central copy of job definitions for jobs run on target servers. Target servers connect periodically to their master server to update their list of jobs to perform. If a new job exists, the target server downloads the job and disconnects from the master server. After the target server completes the job, it reconnects to the master server and reports the status of the job. With SQL Server 2000 Enterprise Edition, master servers can enlist target servers and can defect target servers.

Incorrect Answers:
B: This solution does not address the need to demote the New York City server. It is thus still a master server.

C: In this solution the JobMaster server is enlisted as a target server of the New York City server. This solution also does not address the need to demote the New York City server. It is thus still a master server.

D: In this solution the New York City server is not a target server of the JobMaster server as it has been defected from the JobMaster server.
转载请注明原文地址:https://kaotiyun.com/show/9uhZ777K
本试题收录于： 微软70228题库微软认证分类
0

微软70228

微软认证

相关试题推荐
随机试题
最新回复(0)