2. 计算机
  3. You are the administrator of a SQL Server 2000 computer. You want to set up snapshot replication on the server. The server will

You are the administrator of a SQL Server 2000 computer. You want to set up snapshot replication on the server. The server will

admin2009-05-19  25
问题 You are the administrator of a SQL Server 2000 computer. You want to set up snapshot replication on the server. The server will serve as Publisher and Distributor for a minimum of 40 Subscribers.

Currently, you want to publish 3GB of data, but the data is expected to grow over time. Subscribers will receive a new snapshot each month.

You want to minimize the workload on the Publisher/Distributor. Which two actions should you take to configure snapshot replication? (Each correct answer presents part of the solution. Choose two)
选项 A、Store the snapshot in the default folder on the Publisher/Distributor.
B、Store the snapshot in an alternative folder on the Publisher/Distributor.
C、Store the snapshot in a shared folder on a file server.
D、Create pull subscriptions.
E、Create push subscriptions.
答案C,D
解析 Explanation:
C: In SQL Server 2000 it is possible to store snapshot files in a location other than or in addition to the default location. Alternate locations can be on another server, on a network share, or on removable media. Saving snapshot files in an alternate location can alleviate disk overhead on the Distributor.

However, Subscribers running earlier versions of SQL Server cannot use the alternate snapshot location. When specifying the snapshot location on a network share, it is recommended that that share folder be dedicated for snapshot storage and files. Subscribers that need to access the snapshot files will need Read permission to the snapshot location and appropriate folders. If the snapshot folder is not shared for the appropriate Subscribers, the replication agents cannot access the folder and the replication will fail.

D: With pull subscriptions the Subscriber requests data and updates that are made at the Publisher. Thus allows the user at the Subscriber to determine when the data changes are synchronized. With pull subscriptions the administration of the subscription takes place at the Subscriber.

A feature of pull subscriptions is that the Distribution Agent for snapshot and transactional publications and the Merge Agent for merge publications all run at the Subscriber. This can result in a reduction of the amount of processing overhead on the Distributor. However, if needed, the Distribution Agent or Merge Agent can be run at the Distributor to offload agent processing from the Subscriber.

Incorrect Answers:
A: The default location for snapshot replication files are specified in the Specify Snapshot Folder dialog box that appears in the Configure Publishing and Distribution Wizard and in the Create Publication Wizard. The default location is usually on the Distributor.

B: In SQL Server 2000 it is possible to store snapshot files in a location other than or in addition to the default location. Alternate locations can be on another server, on a network share, or on removable media. Saving snapshot files in an alternate location can alleviate disk overhead on the Distributor, particularly when it is located on another server, or a file server.

E: Push subscriptions are created at the Publisher. This places higher processor overhead at a Publisher using a local Distributor as the Distribution Agent for the snapshot publication runs at the Distributor.
转载请注明原文地址:https://kaotiyun.com/show/orhZ777K
本试题收录于： 微软70228题库微软认证分类
0

微软70228

微软认证

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