MCTS70432.docx

1、MCTS70432MCTS(70-432)单项选择题1、YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.Thereisacomputerwhichhostsseveralapplicationsinyourcompany.Theinstancerunsonthecomputer.AjobnamedDiliveryListiscreated

2、byyou.Thisjobrequiresafiletobewrittentoafileserver.Butbecausethejobcannotaccessthefileserver,itfailstorun.YouintendtoconfiguretheSQLServerAgentservicesothatonlytheSQLServerAgentservicehasreadandwriteaccesstothefileserver.Whichaccounttypeshouldyouuse?（）A.YoushoulduselocalServiceaccountB.Youshouldusen

3、etworkServiceaccountC.YoushouldusedomainaccountD.YoushoulduselocalSystemaccount参考答案：C单项选择题2、YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDB1intheinstance.OnDB1,quitefewlo

4、ggedoperationsareperformed.NowaccordingtotherequirementofthecompanyCIO,youmustvalidatethatthedatabasecanberestoredtoaspecificpointintime.Sowhatactionshouldyouperformtoachievethisgoal?（）A.Youshouldverifythatthesimplerecoverymodelisusedbythedatabase.B.Youshouldverifythatthefullrecoverymodelisusedbythe

5、database.C.Youshouldverifythatthechecksumpageverifyoptionisusedbythedatabase.D.Youshouldverifythatthebulk-loggedrecoverymodelisusedbythedatabase.参考答案：B单项选择题3、YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2

6、008instance.ThereisaSQLServer7.0database.YouupgradethedatabasetotheSQLServerinstance.Accordingtothecompanyrequirement,youmustmakesurethatsuspectpagescanbedetectedinthedatabase.Sowhatactionshouldyouperformtoachievethisgoal?（）A.Forthedatabase,youshouldturnontheTRUSTWORTHYdatabaseoptionB.Forthedatabase

7、,thePAGE_VERIFYdatabaseoptionshouldbesettoCHECKSUMC.Forthedatabase,thedatabasecompatibilityleveloptionshouldbesetto10D.Forthemodeldatabase,thePAGE_VERIFYdatabaseoptionshouldbesetto TORN_PAGE_DETECTION.参考答案：B单项选择题4、YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadminist

8、ratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.YouconfiguretheSQLServerinstancetousethe-T1222and-T1204traceflagsduringstartup.Youmustmakesurethatyourfailurerecoveryplanperformsbackupoftheuseofthetraceflags.Sowhatactionshouldyouperformtoachievethisgoal?（）A.Youshouldbackupthemaste

9、rdatabaseB.Youshouldbackupthedefault.trcfileC.YoushouldbackuptheSQLServerregistryhive.D.Youshouldbackuptheresourcedatabase参考答案：C单项选择题5、YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.Accordingto

10、thecompanyrequirement,thenamesofalluser-definedstoredproceduresmustcontaintheprefixusp_onallinstances.Besidesthis,youmustmakesurethatstoredproceduresthatdonotcontainthisprefixcannotbecreatedbyyou.Whatshouldyoudo?（）A.Apolicyshouldbecreated.Thepolicytargetsthenameofthestoredprocedurethatisevaluatedond

11、emand.B.Apolicyshouldbecreated.Thepolicytargetsthenameofthestoredprocedurethatisevaluatedonchange.C.Aconditionshouldbecreated.TheconditiontargetsthenameofthestoredprocedurethatisevaluatedonchangeD.Aconditionshouldbecreated.Theconditiontargetsthenameofstoredprocedurethatisevaluatedondemand.参考答案：B单项选择

12、题6、ouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.Nowforanewapplication,aSQLServer2008instancehastobeinstalledonanexistingserver.TheservercontainsadefaultSQLServer2005instance.YourcompanyCIOwantstheircorrespondingcertifiedthird-partyapp

13、licationscanaccesstobothdatabaseinstances.Thecompanyassignsthistasktoyou.Youmustachievethisbyusingaslittledatabaseadministrativeeffortaspossible,andneverchangetheexistingapplicationenvironments.Whatshouldyoudo?（）A.YoushouldinstallSQLServer2008asthedefaultinstance,andconfigurethenewapplicationtouseth

14、edefaultinstanceB.YoushouldupgradetheSQLServer2005applicationtouseSQLServer2008C.YoushouldupgradetheSQLServer2005instancetoaSQLServer2008instanceD.YoushouldinstallSQLServer2008asanamedinstance,andmakethenewapplicationusethenewinstance.参考答案：D单项选择题7、YouworkinacompanywhichisnamedWiikigoCorp.Thecompanyu

15、sesSQLServer2008.You aretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.NowyourcompanyCIOassignsatasktoyou.ThecompanyCIOwantsyoutoconfigureFILESTREAMdataandthetworequirementsbelowmustbemet:youmustenableFILESTREAMforfileI/Ostreamingaccess;remoteclientcomputersmustbeable

16、tohavestreamingaccesstoFILESTREAMdata.YoumustmakesurethatFILESTREAMdataisenabled.Whichserviceshouldyouconfigure?（）A.YoushouldconfigureSQLServerVSSWriterB.YoushouldconfigureDistributedFileSystemC.YoushouldconfigureSQLServerD.YoushouldconfigureSQLServerFullText参考答案：C单项选择题8、Youworkinacompanywhichisname

17、dWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.Nowyouareinchargeoftwoinstancesbothofwhichrunonthesamecomputer.OneisaSQLServer2008instance;anotherisaSQLServer2005instance.ThereisadatabasenamedDB1intheSQLServer2008instance.DB1usestheFulltextindexes.Severalrecordsth

18、atincludethewordrootareaddedtoDB1.AnemptyresultsetisreturnedwhentheFulltextindexisqueriedforthewordroot.Youmustmakesurethequerycanreturnrecordsthatcontainthewordroot.Whatshouldyoudo?（）A.YoushouldterminateandrestarttheMSFTESQLserviceB.Youshouldrebuildthefull-textindexC.Thewordrootshouldbeaddedtothest

19、oplistD.Thewordrootshouldbeaddedtothethesaurusfile参考答案：B单项选择题9、YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDworksintheinstance.TheDworksdatabasehasatablenamedOrderthings

20、.TheOrderthingstableispartitionedontheOrderIdcolumn.Thefirstpartitioncontainsintegervaluesgreaterthan100,000,whilethesecondpartitioncontainsintegervaluesbetween1and100,000.Youhavetoaddanewpartition.Thenewpartitionshouldcontainintegervaluesgreaterthan200,000.Whatshouldyoudo?（）A.Anewpartitionfunctions

21、houldbecreatedB.YoushouldchangetheexistingpartitionschemeC.YoushoulduseaMergeclausetochangetheexistingpartitionfunctionD.YoushoulduseaSplitclausetochangetheexistingpartitionfunction参考答案：D单项选择题10、YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanyda

22、tabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDworksintheinstance.NowyougetareportfromuserssayingthatDB1meetsdeadlockproblems.Asthetechnicalsupport,youhavetocapturethedeadlockinformationtotheSQLServererrorlog.Whatshouldyoudo?（）A.FortheAdventureWorksdatabase,enableServerAuditi

23、ngB.Firstyoushouldsettheappropriatetraceflagsasastartupparameter,andthenrestarttheSQLServerinstanceC.YoushouldconfigurethedatacollectorandmakeitcapturethedeadlockgraphsD.YoushouldconfigureaSQLProfilertrace,andmakeitcapturethedeadlockgraphs参考答案：B单项选择题11、YouworkinacompanywhichisnamedWiikigoCorp.Thecom

24、panyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDworksintheinstance.TheDworksdatabasehasatable namedOrderthings.Accordingtothecompanyrequirement,youhavetoexportalldatafromtheOrderthingstabletoafile.Duringtheexport,youmus

25、tmakesurethatthedataexportprocessissavedforreuseandaMicrosoftOfficeOpenXMLdocumentformatisused.Whatshouldyoudo?（）A.YoushouldrunthebulkcopyprogramutilityalongwithanoutputfileandnoformatfileB.YoushouldruntheSQLCmdutilityandsavetheoutputtoafileC.YoushouldruntheSQLImportandExportDataWizardandsavetheoutp

26、uttoafile.D.Youshouldrunthebulkcopyprogramutilityalongwithaformatfileandanoutputfile.参考答案：C单项选择题12、YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasewhichisnamedSellingsintheinstan

27、ce.TheSellingsdatabasecontainsatablenamedProductions.Thetableisusedtostoresinformationaboutalltypesofproducts.TheProductionstableisoftenqueriedbyusersonthebasisoftheRadioSizecolumn.TheRadioSizecolumncontainstheNULLvalueforallproductsotherthanRadios.Currentlynoindex existsontheRadionSizecolumn.Accordingtotherequirementofthec