多做题,通过考试没问题!

微软认证考试

睦霖题库>其他计算机考试>微软认证考试

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?()

  • A、Snapshot replication should be set on SQL1. And then SQL2 should be set as a standard subscriber for a standard subscription.
  • B、Transactional replication should be set on SQL1. And then, SQL2 should be set as a standard subscriber for a standard subscription.
  • C、Merge replication should be set on SQL1. And then SQL2 should be set as a standard subscriber for an updateable subscription.
  • D、Transactional replication should be set on SQL1. And then, SQL2 should be set as a standard subscriber for an updateable subscription.
正确答案:B
答案解析:
进入题库查看解析

微信扫一扫手机做题