首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
30
问题
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
微软认证
相关试题推荐
Fastingglucose(葡萄糖)andinsulin(胰岛素)levelsremainwithinnormalrangeforwomenusinginjectableororalcontraception,withonl
Writeanessaybasedonthechart.Inyourwriting,youshould1)describethediagram,and2)giveyourcomments.
Artificialheartshavelongbeenthestuffofsciencefiction.In"Robocop",snazzycardiacdevicesaremadebyYamahaandJense
Theideaisasaudaciousasitaltruistic:provideapersonallaptopcomputertoeveryschoolchild—particularlyinthepoorestp
Conversationsaboutelderlyparentsandtechnologyusuallycenteronsafety,inparticularondevicesdesignedtoalertacallc
Adealisadeal—except,apparently,whenEntergyisinvolved.Thecompany,amajorenergysupplierinNewEngland,provokedjus
BedwettingMillionsofkidsandteenagersfromeverypartoftheworldwetthebedeverysinglenight.It’ssocommonthatt
UsingFacebookmakespeoplesadder,atleastaccordingtosomeresearch.Burjustwhatisitaboutthesocialnetworkthattakes
Superiorcustomerservicecanbeanessentialsourceofstrengthascompaniesemergefromtherecession,butmanagersneedtoun
Parentsarenottheonlyonesresponsiblefortheirchildren.Oursocialresponsibilityisatitsgreatestwhenparentsareunab
随机试题
Academicdishonestyisnothingnew.Aslongastherehavebeenhomeworkassignmentsandtests,therehavebeencheaters.Theway
将持有至到期投资重分类为可供出售金融资产的,应在重分类日按其公允价值,借记“可供出售金融资产”科目,按其账面余额,贷记“持有至到期投资”科目,按其差额,贷记或借记()科目。
原始凭证记载的各项内容( )。
家住沈阳的赵力先生与爱人李珍同岁,现年38岁,已有一个10岁的女儿和一个7岁的儿子。赵力为个体工商户,一直靠收购废旧钢材为生。赵力自幼顽皮、厌学,只读了两年书,现在每天靠助手读报和看电视获取信息,但天资聪颖,善交际,生意一直不错。他深觉知识不够,扩大经营力
当其他条件不变而资本的价格下降时,企业的生产成本会随之下降,而生产成本的下降会刺激企业扩大生产规模,从而引发劳动力需求的上升,这是()。
2019年6月1日,企业将债权投资重分类为其他债权投资,重分类日公允价值为800万元,账面价值为780万元;2019年6月20日,企业将该其他债权投资出售,所得价款为830万元,则出售时确认的投资收益为()万元。
评估求助者的心理、生理及社会功能状态,要求咨询师确定()。
()评估是鉴定招聘效率的一个重要指标。
下面是一篇存在问题的公文。阅读后回答问题。××市人民政府文件××[2008]20号
Whensheinterviewsteachingcandidates,principalLaurelTellerfavorstheoneswhoshowtheyhaveaheartforchildren,notju
最新回复
(
0
)