首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of a SQL Server 2000 computer. You want to set up snapshot replication on the server. The server will
You are the administrator of a SQL Server 2000 computer. You want to set up snapshot replication on the server. The server will
admin
2009-05-19
10
问题
You are the administrator of a SQL Server 2000 computer. You want to set up snapshot replication on the server. The server will serve as Publisher and Distributor for a minimum of 40 Subscribers.
Currently, you want to publish 3GB of data, but the data is expected to grow over time. Subscribers will receive a new snapshot each month.
You want to minimize the workload on the Publisher/Distributor. Which two actions should you take to configure snapshot replication? (Each correct answer presents part of the solution. Choose two)
选项
A、Store the snapshot in the default folder on the Publisher/Distributor.
B、Store the snapshot in an alternative folder on the Publisher/Distributor.
C、Store the snapshot in a shared folder on a file server.
D、Create pull subscriptions.
E、Create push subscriptions.
答案
C,D
解析
Explanation:
C: In SQL Server 2000 it is possible to store snapshot files in a location other than or in addition to the default location. Alternate locations can be on another server, on a network share, or on removable media. Saving snapshot files in an alternate location can alleviate disk overhead on the Distributor.
However, Subscribers running earlier versions of SQL Server cannot use the alternate snapshot location. When specifying the snapshot location on a network share, it is recommended that that share folder be dedicated for snapshot storage and files. Subscribers that need to access the snapshot files will need Read permission to the snapshot location and appropriate folders. If the snapshot folder is not shared for the appropriate Subscribers, the replication agents cannot access the folder and the replication will fail.
D: With pull subscriptions the Subscriber requests data and updates that are made at the Publisher. Thus allows the user at the Subscriber to determine when the data changes are synchronized. With pull subscriptions the administration of the subscription takes place at the Subscriber.
A feature of pull subscriptions is that the Distribution Agent for snapshot and transactional publications and the Merge Agent for merge publications all run at the Subscriber. This can result in a reduction of the amount of processing overhead on the Distributor. However, if needed, the Distribution Agent or Merge Agent can be run at the Distributor to offload agent processing from the Subscriber.
Incorrect Answers:
A: The default location for snapshot replication files are specified in the Specify Snapshot Folder dialog box that appears in the Configure Publishing and Distribution Wizard and in the Create Publication Wizard. The default location is usually on the Distributor.
B: In SQL Server 2000 it is possible to store snapshot files in a location other than or in addition to the default location. Alternate locations can be on another server, on a network share, or on removable media. Saving snapshot files in an alternate location can alleviate disk overhead on the Distributor, particularly when it is located on another server, or a file server.
E: Push subscriptions are created at the Publisher. This places higher processor overhead at a Publisher using a local Distributor as the Distribution Agent for the snapshot publication runs at the Distributor.
转载请注明原文地址:https://kaotiyun.com/show/orhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
Whenpeopletalkabouta"north-southdivide"inBritain,theyusuallyrefertohouseprices,employmentandtheratioofprivat
Thenewaircraftrepresentsa$250mbetbyBombardierthatMexicocouldprovidenotjustroutinelabourbutmanufacturingthat
Fastingglucose(葡萄糖)andinsulin(胰岛素)levelsremainwithinnormalrangeforwomenusinginjectableororalcontraception,withonl
SomepeoplesaythattheInternetprovidespeoplewithalotofvaluableinformation.Othersthinkaccesstosomuchinformation
Writealettertoacompanydecliningajoboffer.Inyourletter,youshouldappreciatethejoboffer,andstateyourreason(s)
Forthefirsttime,GeorgeBushhasacknowledgedtheexistenceofsecretCIAprisonsaroundtheworld,wherekeyterroristsuspe
DespiteincreasedairportsecuritysinceSeptember11th,2001,thetechnologytoscanbothpassengersandbaggageforweaponsan
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
如果WindowsXP能够识别网络适配器如何安装网络适配器。
YouaretheadministratorofaSQLServer2000computer.TheservercontainsadatabasenamedAccounting.Thedatafilesarecon
随机试题
《巴塞尔协议》将银行资本划分为______两档。
在药品标签上为了标示药品性质必须印有规定标识的有
溃疡性结肠炎紧急手术指征不包括
根据《土地管理法》规定,建设单位或者个人对责令限期拆除的行政处罚决定不服的,可以在接到责令限期拆除决定之日起()日内,向人民法院起诉。
某公司有A、B、C三项业务,分别提供不同的产品和服务。为寻求企业资源的最佳组合,该公司采用波士顿矩阵对上述三项业务进行了分析,结果如图3—1所示。为了进一步预测B业务的产品市场,该公司的咨询人员讨论了各种预测方法。其中甲咨询工程师认为:移动平均法是一种
2017年4月1日,无权代理人甲以A公司的名义签发一张100万元的银行承兑汇票给公司,该汇票上记载收款人为B公司,付款人为乙银行,付款日期为2017年7月1日。甲在该汇票上签章。2017年4月5日,B公司在明知甲没有代理权的情况下,仍将该汇票背
TheauthorappearstoviewfablesasTheRoman,AztecandEuropeanculturesarementionedinorderto
WindowsXP系统提倡所有的分区都使用NIFS格式,是因为()。
DreiserisgenerallyregardedasthemostsignificantAmericanwriteroftheschoolknownas______.
TheChinesefilmsuperstaroncesaidthathewouldrather______rememberedasacommonpersonthanasacelebrity.
最新回复
(
0
)