PrepAway - Latest Free Exam Questions & Answers

Tag: currently replication between the server in each of the 12 retail stores

What should you do?

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.)