2. Maintaining SQL Server Instances (13 percent)

Question 1

The Products table in database Sales needs to be replicated to laptops running SQL Server 2008. The laptops
are frequently disconnected from the network. The Products table is often updated then the laptops are
disconnected. Minimize bandwidth usage.

A. Snapshot Replication, Push Subscription
B. Merge, Pull
C. Snapshot, Pull
D. Transactional, Pull

Answer 1

Answer: B
Section: (none)
Explanation/Reference:
Explanation: Merge replication is used in situations where the subscribers are not reliably connected to the
network.
http://msdn.microsoft.com/en-us/library/ms151329.aspx
Merge replication is implemented by the SQL Server Snapshot Agent and Merge Agent. If the publication is
unfiltered or uses static filters, the Snapshot Agent creates a single snapshot. If the publication uses
parameterized filters, the Snapshot Agent creates a snapshot for each partition of data. The Merge Agent
applies the initial snapshots to the Subscribers. It also merges incremental data changes that occurred at the
Publisher or Subscribers after the initial snapshot was created, and detects and resolves any conflicts according
to rules you configure.
The following diagram shows the components used in merge replication.