You are a professional level SQL Sever 2008 Database Administrator. A SQL Server 2008
instance at the New York central site is managed by you, and it is called Ins01. There is a
sales team in your company, and their task is to finish purchase orders for customer
requests. The sales team updates data regularly in a local database by utilizing their
portable computers. When the central site is connected by portable computers, a database
named Sales will be synchronized with the local database. A duplication model will be
created to duplicate the local database to the Sales database. The requirements listed
below should be satisfied by the duplication model: First, when the same data is updated
by multiple users independently, there should be no data conflicts. Secondly, sensitive
data such as product price cannot be updated by the sales team. Thirdly, the data should
be synchronized by the sales team not only at scheduled times but also on demand. The
best model should be identified to have data duplicated, and you should be reduced the
development efforts to the least. Which action will you perform?
A.
You should utilize transactional duplication along with each portable computer that is set
up as a publisher.
B.
You should utilize merge duplication along with each portable computer that is set up as
a subscriber.
C.
You should utilize SQL Server Integration Services (SSIS) to promote the date
modification and pull updates to the Sales database along with the SSIS packages, on
demand.
D.
You should utilize snapshot duplication along with each portable computer that is set up
as a subscriber.