首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
29
问题
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
微软认证
相关试题推荐
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
Achemicalplantshouldberesponsibleforthewaterpollutioninanearbyriver.WritealettertotheCityEnvironmentProtect
Writealettertoacompanydecliningajoboffer.Inyourletter,youshouldappreciatethejoboffer,andstateyourreason(s)
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
Themethodsoftestingaperson’sknowledgeandabilityremainasprimitiveasevertheywere.Afteralltheseyears,education
BedwettingMillionsofkidsandteenagersfromeverypartoftheworldwetthebedeverysinglenight.It’ssocommonthatt
MusicfanshaveoftenviewedMicrosoftassomethinglikeabadcoverband,onethatpumpedoutuninvitingfacsimilesofApple’s
YouaretheadministratorofseveralSQLServer2000computers.Youwanttoretrieveinformationfromanarchivedinventorydata
随机试题
教育督导
关于脊髓神经的叙述,错误的是
甘麦大枣汤的功用天王补心丹的功用
猩红热邪侵肺卫证治以( )猩红热疹后阴伤证治以( )
A.溶解度B.溶化性C.崩解度D.融变时限E.卫生学检查胶囊剂需检查,散剂不用检查的项目
某建设工程有4个实施方案可供选择,方案一的投资额是100万元,年运行成本为15万元;方案二的投资额是110万元,年运行成本为18万元;方案三的投资额是125万元,年运行成本为11万元;方案四的投资额是130万元,年运行成本为16万元。各方案应用环境相同,设
一般认为,态度与品德形成过程经历三个阶段:依从、认同和()。
某单位组织“重走长征路,再励坚强志”活动。计划重走长征路,实地考察土地革命时期中央红军的历史足迹。正确的路线是:
调整活动窗口大小的宏操作是【】。
•Youwillhearthreetelephoneconversationsormessages.•Writeoneortwowordsoranumberinthenumberedspacesonthenote
最新回复
(
0
)