A snapshot of th

参考答案：A

正确答案：CD
解析：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.

正确答案：C

参考答案：D

参考答案：C