可学答题网 > 问答 > MCITP(70-447)题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

You are a professional


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.
参考答案
参考解析:
分类:MCITP(70-447)题库
相关推荐

1、You are a professional

You are a professional level SQL Sever 2008 Database Administrator in an international corporation&e...

2、You are a professional

You are a professional level SQL Server 2005 database administrator in an international corporation&...

3、You are a professional

You are a professional level SQL Server 2005 database administrator in an international corporation&...

4、You are a professional

You are a professional level SQL Server 2005 database administrator in an international corporation&...

5、You are a professional

You are a professional level SQL Server 2005 database administrator in an international corporation&...

6、You are a professional

You are a professional level SQL Server 2005 database administrator in an international corporation&...