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.