You administer a SQL Server 2008 instance named Instance1 at the New York central site.
Your company has a sales team to fulfill purchase orders for customer requests. The sales
team uses portable computers to update data frequently in a local database. When the
portable computers connect to the central site, the local database must be synchronized
with a database named Sales. You plan to create a replication model to replicate the local
database to the Sales database. The replication model must meet the following
requirements: Data conflicts are handled when multiple users update the same data
independently. The sales team cannot update sensitive data such as product price. The
sales team can synchronize data at scheduled times and on demand also. You need to
identify the best model to replicate data by using minimum development efforts. What
should you do?
A.
Use SQL Server Integration Services (SSIS) to push data changes and pull updates to
the Sales database along with the SSIS packages, on demand.
B.
Use merge replication along with each portable computer that is set up as a subscriber.
C.
Use snapshot replication along with each portable computer that is set up as a
subscriber.
D.
Use transactional replication along with each portable computer that is set up as a
publisher.