You work as the database administrator at Domain.com. All database servers run Windows Server 2003 and SQL Server 2005. All client computers run Windows XP Professional with Service Pack 2. The Domain.com network contains a database server named Certkiller -DB02 that runs SQL Server 2005 Enterprise Edition. Certkiller -DB02 hosts a database named CK_Sales. The tables in the CK_Sales database are shown in the following database diagram.
Domain.com has several Sales Representatives that use portable client computers. These portable client computers run SQL Server 2005 Express Edition. Domain.com has developed a new sales tracking application named salesTrack. The salesTrack application provides access to the Customers table in the CK_Sales database. Several Sales Representatives use the salesTrack application as part of Domain.com’s Customer Relationship Management (CRM) strategy. You need to ensure that the Sales Representatives can interact with the CK_Sales database while offline. The Sales Representatives must be able to access information about their customers while offline; must be able to add new customers while offline; and must be able to synchronize with Certkiller -DC02 on demand using Web synchronization.
What should you do? (Each correct answer presents part of the solution. Choose two.)
A.
Implement snapshot replication.
B.
Implement merge replication.
C.
Implement transactional replication.
D.
Configure the portable client computers for pull subscriptions.
E.
Configure the portable client computers for push subscriptions.
Explanation:
To allow offline access to the CK_Sales database and synchronization on demand using Web synchronization, you need to implement merge replication. To enable the portable client computers to synchronize with Certkiller -DC02 on demand using Web synchronization you must configure them for pull subscriptions. During synchronization changes are propagated to the publisher and to other subscribers.
Incorrect Answers:
A: You cannot use snapshot replication to replicate transactions from multiple computers to a single database server. Also, with snapshot replication the entire database is sent during synchronization.
C: Transactional replication requires that data be entered at the Publisher. In this scenario, data will be entered at the subscribers.
E: Push replication does not support synchronization on demand from the subscriber. Only the publisher determines when synchronization occurs.
Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: merge replication [SQL Server replication], about merge replication
Microsoft SQL Server 2005 Books Online (2006), Index: snapshot replication [SQL Server], about snapshot replication
Microsoft SQL Server 2005 Books Online (2006), Index: transactional replication, about transactional replication
Microsoft SQL Server 2005 Books Online (2006), Index: push subscriptions [SQL Server replication]
Microsoft SQL Server 2005 Books Online (2006), Index: pull subscriptions [SQL Server replication]