You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for a financial services company. Replication is configured between two SQL Server 2005 computers, and the servers are respectively named SQL1 and SQL2. Real-time transactional data is stored by the SQL1. And SQL2 is utilized for reporting. The data on SQL01 should not be changed by SQL2. The publication contains a large amount of data. Since you are the database administrator, you need to make sure that data is replicated from SQL1 to SQL2 in as near real-time as possible to confirm accurate reporting during replication. In addition, you need to make sure that this data is replicated securely. Which action should be performed?()
- ASnapshot replication should be set on SQL1. And then SQL2 should be set as a standard subscriber for a standard subscription.
- BTransactional replication should be set on SQL1. And then, SQL2 should be set as a standard subscriber for a standard subscription.
- CMerge replication should be set on SQL1. And then SQL2 should be set as a standard subscriber for an updateable subscription.
- DTransactional replication should be set on SQL1. And then, SQL2 should be set as a standard subscriber for an updateable subscription.