TestKing.comhastwoSQLServer2005computersnamedSQL1andSQL2.Bothserverstakepartinreplication.SQL1isboththePublisheranditsownDistributorofapublicationnamedPub1.Pub1istheonlypublicationonSQL1,andSQL2istheonlySubscriber.Yoursupervisorrequestsastatusreportaboutt

题目

TestKing.comhastwoSQLServer2005computersnamedSQL1andSQL2.Bothserverstakepartinreplication.SQL1isboththePublisheranditsownDistributorofapublicationnamedPub1.Pub1istheonlypublicationonSQL1,andSQL2istheonlySubscriber.Yoursupervisorrequestsastatusreportaboutthereplicationlatencies.UsingReplicationMonitoronSQL1,youneedtofindoutthecurrentlatenciesbetweenthePublisherandDistributoraswellasbetweentheDistributorandSubscriber.Whatshouldyoudo?()

A.SelecttheSubscriptionWatchListtabforSQL1.ViewtheLatencycolumnfortheSQL2subscription.

B.SelecttheAllSubscriptionstabforthePub1publication.ViewtheLatencycolumnfortheSQL2subscription.

C.SelecttheTracerTokenstabforthePub1publication.SelecttheInsertTracer OptionandwaitfortherequestedlatencyvaluesfortheSQL2subscriptiontoappear.

D.SelecttheSubscriptionWatchListtabforSQL1.Double-clicktheSQL2subscription.ViewthedurationdetailsonthePublishertoDistributorHistorytabaswellasontheDistributortoSubscriberHistorytab.


相似考题
参考答案和解析
参考答案:C