You work as a database administrator at Domain.com. Domain.com have 12 retail stores, each
store is equipped with their own SQL Server 2008 computer.
A database table named CK-Sales is used to store point-of-sale transactions. Furthermore,
CK-Sales also hosts sales information from all 12 of the Domain.com stores to accommodate
customer returns of products. Consequently the data should be refreshed from the main office to
all 12 retail stores every hour, on the hour. To this end you make use of a trigger called
trg_Coupon to produce sales coupons based on customer sales and buying patterns. Currently
replication between the server in each of the 12 retail stores and a middle server in the main office
occurs in real time. You should receive instruction to eliminate this replication.
What should you do? (Each correct answer presents part of the solution. Choose TWO.)
A.
You should consider using multiple merge publications, one at every store and one in the main office.
B.
You should consider using transactions log between all the servers in the Domain.com domain.
C.
You should consider using snapshot replication.
D.
You should consider using merge replication.
E.
You should consider setting the trg_Coupon trigger on the server in each retail store to use the
NOT FOR REPLICATION option.
F.
You should consider setting the trg_Coupon trigger on the server in each retail store to use the
FOR REPLICATION option.