You are a database administrator for a financial services company. You are configuring replication between two SQL Server 2005 computers named SQL1 and SQL2. SQL1 stores real-time transactional data. SQL2 is used for reporting. SQL2 must not change data on SQL1. The publication contains a large amount of data. You need to ensure that during replication, data is copied from SQL1 to SQL2 in as near real-time as possible to ensure accurate reporting. You need to ensure that this data is copied securely. What should you do?
A.
Configure snapshot replication on SQL1. Configure SQL2 as a standard subscriber for a standard subscription.
B.
Configure merge replication on SQL1. Configure SQL2 as a standard subscriber for an updateable subscription.
C.
Configure transactional replication on SQL1. Configure SQL2 as a standard subscriber for an updateable subscription.
D.
Configure transactional replication on SQL1. Configure SQL2 as a standard subscriber for a standard subscription.
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 subscription should not be configured as updatable by the subscriber as SQL-2 is not allowed to change the data.