相关考题

单项选择题 YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.Thereisareportwhichisoftenexecutedduringbusinesstime.Thereisastoredprocedurethatisusedasthedatasourceforthereport.Yougetareportfromuserssayingthattheyreceivethedatareturnedbythereportbutthedataisinconsistent.Asthetechnicalsupport,youcheckandfindthatphantomreadscausethisproblem.Youmustmakesurethatconsistentdataisreturnedbythereportwhilenotaffectingotherusers.Sowhatactionshouldyouperformtoachievethisgoal?()

单项选择题 YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.Nowaccordingtothecompanyrequirement,youaredesigningaconsolidatedrepositoryofperformancedata.Youmustmakesurethatthefourrequirementsbelowaremet:thedatacollectorisusedtogatherperformanceinformation;asingledatabasestoresperformanceinformationforallinstances;performanceinformationthatisolderthan15daysisdeleted;reducetheadministrativeefforttomanageperformancetotheleast.Sowhatactionshouldyouperformtoachievethisgoal?()

单项选择题 YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.Youaregoingtousethedatacollectortogatherperformancedataperiodicallyonallinstances.Youmuststoreallcollecteddatainthesamedatabase.Thisdatabaseishostedonasingleinstance.Everyfivehours,youhavetocollectandloadperformancedatainthemanagementdatawarehouse.Whichdatacollectionprocessshouldyouimplement?()