You are a database administrator for AIOTestKing.com. The company’s manufacturing floor has three automated testing areas for finished items. Each testing area uses SQL Server 2005 to store test results. You need to develop a replication strategy to ensure that test results flow continuously from the testing areas to the central SQL Server as quickly as possible. The test results are used for reporting. What should you do?
A.
Create a separate transactional publication at each of the testing areas for the test results.Create a merge subscription on each distributor to the central server.
B.
Create a separate snapshot publication at each of the testing areas for the test results.Create a merge subscription on each distributor to the central server.
C.
Create a separate snapshot publication at each of the testing areas for the test results.Create a pull subscription on the central server to each of the testing area publications.
D.
Create a separate transactional publication at each of the testing areas for the test results.Create push subscriptions on each of the testing areas to the central server.
Explanation:
Transactional replication typically starts with a snapshot of the publication database objects and data. As soon as the initial snapshot is taken, subsequent data changes and schema modifications made at the Publisher are usually delivered to the Subscriber as they occur (in near real time). The data changes are applied to the Subscriber in the same order and within the same publication, transactional consistency is guaranteed. By default, Subscribers to transactional publications should be treated as read-only, because changes are not propagated back to the Publisher. Push subscriptions are typically used when the subscribers are treated as read only.