You work as a database administrator at TestKing.com. TestKing.com has 12 separate
branch offices and a main office, each office is equipped with their own SQL Server 2008 computer.

A database table named TK-Sales is used to store point-of-sale transactions. Furthermore,
TK-Sales also hosts sales information from all 12 of the TestKing.com branch offices to
accommodate customer returns of products. Consequently the data should be refreshed
from the main office to all 12 branch offices every hour, on the hour. To this end you make
use of a trigger called Stats_Trigger to produce sales statistics based on customer sales and
buying patterns. Currently replication between the server in each of the 12 branch offices
and a middle server in the main office occurs in real time. You need to decide which type of
replication would be best in this scenario. You should also eliminate the replication of the
data that is produced by the trigger.

What steps should you take? (Each correct answer presents part of the solution. Choose TWO.)