MCITP(70431)真题精选.docx

MCITP(70431)真题精选.docx

《MCITP(70431)真题精选.docx》由会员分享，可在线阅读，更多相关《MCITP(70431)真题精选.docx（20页珍藏版）》请在冰点文库上搜索。

MCITP（70-431）真题精选

　　[多项选择题]

　　1、YouarepreparingforanewinstallationofSQLServer

　　2005.Youneedtoselecttheprotocolsthatclientcomputersmightusetoconnecttothe

　　server.Whichtwoprotocolscanyouusetoachievethisgoal?

（）

　　A.NamedPipes

　　B.TCP/IP

　　C.SharedMemory

　　D.VirtualInterfaceAdapter（VIA）

　　E.Multiprotocol

　　参考答案：

A,B

　　[单项选择题]

　　2、YourcompanyhastwoSQLServer2005computersnamedSQL1andSQL2.AuserinyourcompanynamedEricwritesmanyadhocqueriesagainstthecompany

　　databases.ErichasaccesstotheCustomerdatabaseonSQL1.HedoesnothaveaccesstotheSalesdatabaseonSQL2.YouneedtoensurethatEriccanwritequeriesthatjoininformationfromboth

　　servers.Whatshouldyoudofirst?

（）

　　A.CreatealinkedserveronSQL1toSQL2.Configurethelinkedservertouse

　　impersonation.

　　B.CreatealinkedserveronSQL1toSQL2.Configurethelinkedservertousemapped

　　logins.

　　C.InstructErictowritethequeriesonSQL2byusingtheOPENQUERYstatementandspecifyingSQL1astheserver

　　name.

　　D.InstructErictospecifySQLServerobjectnamesbyusingfour-part

　　notation.

　　参考答案：

B

　　[单项选择题]

　　3、YouconfigureanewSQLServer2005computertouseTCP/IPwithalldefault

　　settings.Yourcorporatepolicyrequiresthateachserverusea

　　firewall.YoufindthatyoucanconnecttotheSQLServerinstancefromthelocal

　　computer.However,clientcomputerscannotconnecttotheSQLServer

　　instance.Youneedtoidentifythemostlikelycauseoftheconnection

　　issues.Whatshouldyoudofirst?

（）

　　A.Ensurethatport1433isopeninyour

　　firewall.

　　B.Ensurethatport443isopeninyour

　　firewall.

　　C.EnsurethatclientcomputersconnectbyusingSharedMemory

　　protocol.

　　D.Ensurethattheserverisnot

　　paused.

　　参考答案：

A

　　[多项选择题]

　　4、YourcompanyusesSQLServer

　　2005.Usersreportthatreportexecutionis

　　slow.Youinvestigateanddiscoverthatsomequeriesdonotuseoptimalexecution

　　plans.Youalsonoticethatsomeoptimizerstatisticsaremissingandothersareoutof

　　date.Youneedtocorrecttheproblemsothatreportsexecutemore

　　quickly.WhichtwoTransact-SQLstatementsshouldyouuse?

（）

　　A.DBCCCHECKTABLE

　　B.ALTERINDEXREORGANIZE

　　C.UPDATESTATISTICS

　　D.CREATESTATISTICS

　　E.DBCCSHOW_STATISTICS

　　F.DBCCUPDATEUSAGE

　　参考答案：

C,D

　　[单项选择题]

　　5、YouareresponsibleforimplementingmaintenancejobsonaSQLServer2005database

　　server.CertainjobsruneverySundayandotherjobsrunatthebeginningofevery

　　month.Youneedtoschedulethejobsinthewaythatusestheleastamountofadministrative

　　effort.Whatshouldyoudo?

（）

　　A.Createajobschedulethatrunsevery

　　Sunday.Assignweeklytaskstothis

　　schedule.Createasecondschedulethatrunsonthefirstdayofevery

　　month.Assignmonthlytaskstothis

　　schedule.

　　B.Createajobforeachtaskthatrunsoncea

　　day.UseaTransact-SQLstatementtocheckthedateanddayofthe

　　week.IfthedayiseitheraSundayorthefirstdayofthemonth,executethe

　　code.

　　C.Createajobschedulethatrunsoncea

　　day.Assignjobstothisjob

　　schedule.IfthedayiseitheraSundayorthefirstdayofthemonth,executethe

　　jobs.

　　D.Createajobforeachtaskthatrunsonceaweekon

　　Sunday.Addasecondjobschedulethatrunsthejobonthefirstofthe

　　month.

　　参考答案：

A

　　[多项选择题]

　　6、YourcompanyWebsiteincludesapagethatcustomersusetosendfeedbackaboutthecompanyandits

　　products.YouuseaSQLServer2005databasetostorethecommentsintheCommentscolumnofatablenamed

　　Feedback.Youneedtoimplementfull-textsearchingsothatyoucanrunreportsonthe

　　comments.Whichtwoactionsshouldyouperform?

（）

　　A.CreateanonclusteredindexontheComments

　　column.

　　B.ExecutetheUSEMasterTransact-SQL

　　statement.

　　C.Createafull-text

　　catalog.

　　D.Createafull-textindexontheComments

　　column.

　　参考答案：

C,D

　　[单项选择题]

　　7、YouarecreatingaSQLServer2005databaseforamortgage

　　company.ThedatabasewillsupportanewWeb-basedapplicationthatwillhandleupto1,000simultaneous

　　users.Thisapplicationmustquicklydisplaytheresultsofcalculation-intensiveoperations,suchascalculatingmortgagepaymentsandamortization

　　schedules.Youneedtoensurethatthedatabaseprocessescalculationsasquicklyandefficientlyas

　　possible.Whatshouldyoudo?

（）

　　A.ImplementparameterizedTransact-SQLqueriesinthe

　　application.

　　B.ImplementTransact-SQLstoredproceduresinthe

　　database.

　　C.ImplementCLRstoredproceduresinthe

　　database.

　　D.ImplementdistributedWeb

　　services.

　　参考答案：

C

　　[单项选择题]

　　8、YouworkwithaSQLServer2005databasethatprovidesbankinginformationfor

　　customers.Youwantcustomerstoseebankingreportsthatcombinedatathatisretrievedfromthedatabasewithreal-timeinvestmentinformationthatcomesfromaWebserviceprovidedbyathird

　　party.Theinvestmentinformationmustbecurrentwhenthereportsare

　　executed.Youneedtocreatetheappropriateobjectsthatsupportthe

　　reports.Whatshouldyoudo?

（）

　　A.PublishthedatainthedatabaseasanXMLWebservicebyusingtheFORXMLAUTO

　　clause.

　　B.Createatabletostorethebankinginformationforeach

　　customer.CreateatriggerthatfireswhendataisinsertedintothetablethatjoinswiththedatacomingfromtheWeb

　　service.

　　C.CreateaTransact-SQLstoredprocedurethatusesatemporarytabletostorethebankinginformationforeach

　　customer.UpdatethetablewiththevaluesfromtheWeb

　　service.

　　D.HaveadeveloperinyourcompanycreateanassemblythatcallstheremoteWeb

　　service.CreateaCLRfunctionbyusingthe

　　assembly.CalltheCLRfunctionandcombinetheresultswithbankinginformationinthe

　　database.

　　参考答案：

D

　　[多项选择题]

　　9、YourcompanyusesSQLServer

　　2005.Youareimplementingaseriesofviewsthatareusedinadhoc

　　queries.Theviewsareusedtoenforceyourcompanyssecuritypolicyofabstracting

　　data.Someoftheseviewsperform

　　slowly.Youcreateindexesonthoseviewstoincreaseperformance,whilestillmaintainingthecompanyssecurity

　　policy.Oneoftheviewsreturnsthecurrentdateasoneofthe

　　columns.TheviewreturnsthecurrentdatebyusingtheGETDATE（）

　　function.Thisviewdoesnotallowyoutocreatean

　　index.Youneedtocreateanindexonthe

　　view.Whichtwoactionsshouldyouperform?

（）

　　A.Removealldeterministicfunctioncallsfromwithinthe

　　view.

　　B.Removeallnondeterministicfunctioncallsfromwithinthe

　　view.

　　C.Schema-bindallfunctionsthatarecalledfromwithinthe

　　view.

　　D.CreatetheviewandspecifytheWITHCHECKOPTION

　　clause.

　　参考答案：

B,C

　　[单项选择题]

　　10、YourcompanyusesaSQLServer2005

　　database.CustomerdatafromyourtradingpartnersisimportedintotheCustomerstableevery

　　night.YouneedtoensurethatthecustomerrecordisupdatedifitalreadyexistsintheCustomers

　　table.Iftherecorddoesnotexist,thedataneedstobeinsertedintotheCustomers

　　table.Whatshouldyoudo?

（）

　　A.CreateaFOR

　　trigger.

　　B.CreateanINSTEADOF

　　trigger.

　　C.CreateanAFTER

　　trigger.

　　D.CreateaDDL

　　trigger.

　　参考答案：

B

　　[多项选择题]

　　11、Yourcompanyusesamission-criticaldatabasenamedDB1,whichislocatedonaservernamedSQL1.YouwanttomirrorDB1onasecondservernamedSQL2.Beforeyoucanestablishdatabasemirroring,youneedtoprepareDB1andtheserversfor

　　mirroring.Whichthreeactionsshouldyouperform?

（）

　　A.SettherecoverymodelofDB1onSQL1tobulk-logged

　　recovery.

　　B.SettherecoverymodelofDB1onSQL1tofull

　　recovery.

　　C.BackupDB1onSQL1.RestorethebackuponSQL2;

　　specifytheNORECOVERY

　　option.

　　D.BackupDB1onSQL1.RestorethebackuponSQL2;

　　specifytheSTANDBY

　　option.

　　E.BackupDB1onSQL1.RestorethebackuponSQL2;

　　specifytheRECOVERY

　　option.

　　F.Createendpointsonallparticipating

　　servers.

　　G.SettheAutoShrinkpropertyofDB1onSQL1to

　　false.

　　参考答案：

B,C,F

　　[单项选择题]

　　12、YourcompanyhastwoSQLServer2005computersnamedSQL1andSQL2.TransactionlogshippingoccursfromSQL1toSQL2byusingdefaultSQLServerAgentschedule

　　settings.YouneedtoreconfiguretransactionlogshippingtoprovideminimumlatencyonSQL2.Whatshouldyoudo?

（）

　　A.OnSQL1,reschedulethetransactionlogbackupjobsothatitoccursevery

　　minute.OnSQL2,maintaindefaultschedulesettingsforboththelogshippingcopyandtherestore

　　jobs.B.OnSQL1,changethescheduletypeforthetransactionlogbackuptoStartautomaticallywhenSQLServerAgent

　　starts.OnSQL2,changethescheduletypesforboththelogshippingcopyandtherestorejobstoStartautomaticallywhenSQLServerAgent

　　starts.

　　C.OnSQL1,maintaindefaultschedulesettingsforthetransactionlogbackup

　　job.OnSQL2,changethescheduletypesforboththelogshippingcopyandtherestorejobstoStartautomaticallywhenSQLServerAgent

　　starts.

　　D.OnSQL1,reschedulethetransactionlogbackupjobsothatitoccursevery

　　minute.OnSQL2,rescheduleboththelogshippingcopyandtherestorejobssothattheyoccurevery

　　minute.

　　参考答案：

D

　　[单项选择题]

　　13、AfullbackupofyourdatabasenamedDB1iscreatedautomaticallyatmidnightevery

　　day.DifferentialbackupsofDB1occurtwiceeachdayat

　　10:

00andat

　　16:

00.Adatabasesnapshotiscreatedeverydayat

　　noon.AdeveloperreportsthatheaccidentallydroppedthePricelisttableinDB1at

　　12:

30.ThelastupdatetoPricelistoccurredoneweek

　　ago.YouneedtorecoverthePricelist

　　table.Youwanttoachievethisgoalbyusingtheminimumamo