You are mastering the company database; there are 15 retail stores in your company. On its
own SQL Server 2008 computer, every retail store keeps transactions of point-of-sale in a
database table called Saling. The Saling table also includes sales information from other
stores to enable customer returns to any of the 15 retail stores. You could refresh the data in
the main office to every retail store every hour. You should use trigger called trg_Coupon to
produce sales coupons based on customer sales and buying patterns. Through using the
fewest number of steps, you should set replication between the server in every retail store
and a middle server in the mainoffice. in real time. You should not have the Replication.
Which is the correct answer?
A.
Snapshot replication should be utilized. You should set the trg_Coupon trigger on the
server in every store to utilize the NOT FOR REPLICATION option.
B.
You should utilize merge replication. You should set the trg_Coupon trigger on the server
in each retail store to use the NOT FOR REPLICATION option.
C.
You should utilize transactions log between the server in each retail store and the central
server in the main office.
D.
You should build multiple merge publications, one at every store and one in the main
office.