单项选择题
A.You should allow failback only during non-business hours
B.You should immediately allow failback
C.You should prevent automatic failback
D.You should allow failback only during business hours
单项选择题 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?()