YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.Thereisareportwhichisoftenexecutedduringbusinesstime.Thereisastoredprocedurethatisusedasthedatasourceforthereport.Yougetareportfromuserssayingthattheyreceivethedatareturnedbythereportbutthedataisinconsistent.Asthetechnicalsupport,youcheckandfindthatphantomreadscausethisproblem.Youmustmakesurethatconsistentdataisreturnedbythereportwhilenotaffectingotherusers.Sowhatactionshouldyouperformtoachievethisgoal?（）A.You should configure the database for Read Committed Snapshot isolation. B.You should modify the stored procedure to use the Snapshot isolation level C.You should configure the database for Auto Update Statistics asynchronously D.You should modify the stored procedure to use the Repeatable Read isolation level

MCTS(70-432)

单项选择题

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a report which is often executed during business time. There is a stored procedure that is used as the data source for the report. You get a report from users saying that they receive the data returned by the report but the data is inconsistent. As the technical support, you check and find that phantom reads cause this problem. You must make sure that consistent data is returned by the report while not affecting other users. So what action should you perform to achieve this goal?（）

A.You should configure the database for Read Committed Snapshot isolation.
B.You should modify the stored procedure to use the Snapshot isolation level
C.You should configure the database for Auto Update Statistics asynchronously
D.You should modify the stored procedure to use the Repeatable Read isolation level

相关考题

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

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

单项选择题 YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.Theserverhostsdatabasesforseveralmission-criticalapplications.MicrosoftSQLServerManagementStudioexecutesqueriesandithassomeeffect.NowyouintendtolimittheeffectbyusingtheResourceGovernor.YoumustmakesurethatqueriesinitiatedthroughSQLServerManagementStudioislessthan20percentofCPUutilization,besidesthis,youmustmakesurethatqueriesinitiatedbythemission-criticalapplicationscanconsume100percentofCPUutilizationwhenrequired.Sowhatactionshouldyouperformtoachievethisgoal?（）

备案号：湘ICP备14005140号-3

经营许可证号：湘B2-20140064