You work as a database administrator at ABC.com.ABC.com makes use of SQL Server 2008 R2.
ABC.com has a SQL Server 2008 R2 instance that includes a database, named ABC_DB, which
hosts the ProductItems table.
You have been instructed to implement a Replication topology to ensure that the ProductItems
table is replicated to the SQL Server instances running on mobile workstations. Even though the
ProductItems table is constantly refreshed, the ProductItems table should only be refreshed when
a mobile user connects to the ABC.com network.
Your solution should allow for the Replication topology to run in conjunction with the Subscription
type, while keeping the amount of bandwidth consumed to a minimum.
Which of the following options should you include in your strategy? (Choose all that apply.)
A.
A Merge Replication topology.
B.
A Transactional Replication topology.
C.
An Active Directory Replication topology.
D.
A Pull Subscription.
E.
A Push Subscription.
Explanation: