Microsoft
70-432 · Question #151
70-432 Question #151: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #151. The question stem and answer options stay visible for context.
Question
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?
Options
- ASnapshot replication should be utilized. You should set the trg_Coupon trigger on the server
- BYou should utilize merge replication. You should set the trg_Coupon trigger on the server in
- CYou should utilize transactions log between the server in each retail store and the central
- DYou should build multiple merge publications, one at every store and one in the main office.
Unlock 70-432 to see the answer
You've previewed enough free 70-432 questions. Unlock 70-432 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.