单选题
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？（）
发布日期：2020-04-10
Snapshot replication should be set on SQL1. And then SQL2 should be set as a standard subscriber for a standard subscription.
Transactional replication should be set on SQL1. And then， SQL2 should be set as a standard subscriber for a standard subscription.
Merge replication should be set on SQL1. And then SQL2 should be set as a standard subscriber for an updateable subscription.
Transactional replication should be set on SQL1. And then， SQL2 should be set as a standard subscriber for an updateable subscription.
标签： professional level sql server 2005
题王网让考试变得更简单
扫码关注题王，更多免费功能准备上线！
此试题出现在
CMS专题
CMS专题
其他考试
社会知觉，也称（ ），即个体对他人、群体以及对自己的知觉。
电子商务网站的界面设计原则
洋地黄中毒的表现应除外（）
水体污染监测可分为水体污染现状监测和（）。
在程序设计中，语句块BEGIN…END可有可无。
计算题：已知V带传动所传递的功率P=7.5kW，带速v=10m/s，现测得张紧力F0=1125N，试求紧边拉力F1和松边拉力F2各等于多少
多角化增长
学习策略
医院护理三级管理体制是指（）。
葡萄胎和侵蚀性葡萄胎镜下结构的主要区别是（）.
暂无相关推荐~
You are a professional level SQL Server 2005 database administrator in an intern...
You are a professional level SQL Sever 2008 Database Administrator in an interna...
You are a professional level SQL Sever 2008 Database Administrator in an interna...
You are a professional level SQL Server 2005 database administrator in an intern...
You are a professional level SQL Sever 2008 Database Administrator in an interna...
You are a professional level SQL Server 2005 database administrator in an intern...
You are a professional level SQL Server 2005 database administrator in an intern...
You are a professional level SQL Sever 2008 Database Administrator in an interna...
You are a professional level SQL Sever 2008 Database Administrator in an interna...
You are a professional level SQL Server 2005 database administrator in an intern...