You are the administrator of your company network. And you’re in charge of a SQL Server 2008 infrastructure. Now you manage a SQL Server 2008 instance named Instance PK1 at the Chicago central site. In your company, there’re several departments, such as sales department and service department.
The sales department is in charge of dealing with the purchase orders according to the requirements of customers. In a local database, the sales team uses laptop to update data very often. The local database must be in synchrony with a database named Selling when the laptop link to the Chicago central site. You intend to replicate the local database to the Selling database by developing a replication model which must satisfy the requirements below:
1. The sales team can synchronize data at scheduled times and on demand also.
2. The sales department cannot update sensitive data such as origin of the products.
3. When losts of users update the dame data independently, data conflicts are solved. You have to choose the best model to replicate data while using as little development efforts as possible. So what should you do?
A.
You should use merge replication along with each laptop which is set up as a subscriber.
B.
You should use snapshot replication along with each portable computer that is set up as a subscriber.
C.
You should use transactional replication along with each portable computer that is set up as a publisher.
D.
You should use SQL Server Integration Services (SSIS) to push data changes and pull updates to the Sales database along with the SSIS packages, on demand.