关于链霉素的描述正确的有

xchangeServer2003servershowanexcessivenumberof401errors.Youneedtoreducethenumberof401errorsidentifiedinthelogs.Whatshouldyoudo？（）

A.A

B.B

C.C

D.D

rosoftMessagingandSecurityFeaturePack.Themessaginginfrastructureisconfiguredtosupporttheremotewipefeature.WhenanadministratorattemptstoperformaremotewipeofaWindowsMobilebaseddevice，theadministratorreceivesa401errormessage.Youneedtoensurethattheadministratorisauthorizedtoperformremotewipesonly.Whatshouldyoudo？（）

A.GranttheadministratormembershipintheDomainAdministratorsgroup.

B.GranttheadministratormembershipintheExchangeAdministratorsgroup.

C.AddthenewadministratoraccounttotheDiscretionaryAccessControlList（DACL）oftheMicrosoftExchangeActiveSyncAdministrationfolder.

D.SelecttheDirectorySecuritytaboftheExchangeServeradministrationWebsite，andthenconfigureRead，Write，andDirectoryBrowsingpermissions.

Youare adatabase developer.YouplantodesignadatabasesolutionbyusingSQLServer2008.You are creating adataba seto supportthe office manager.Your database modelhasthe following structure.

Thedatabasedesignhasthefollowing businessrequirements:Anemployeecanbeassignedmorethanone task.Uponcompletion,thetaskisdeleted.Whenataskisdeleted,theassociatedassignmentisdeleted.When an employee isnolonger availabletocomple tea task,theemployee linkto the assignmentisreplacedwithaNULLvalue.Youneed toimplementthebusinessrequirementstomaintaindataintegrity.

Whatshouldyoudo?（）

satablenamedInventory.ThetablecontainsacolumnnamedPrice.AcompanypolicystatesthatthevalueinthePricecolumncannotbedecreasedbymorethan10percentinanysingledatabaseoperation.UpdatestothePricecolumnaremadebyvariousmeans，includingbyusingadhocqueries.Youneedtoensurethatthiscompanypolicyisenforced.Whatshouldyoudo？（）

A.CreateatriggerthatrollsbackchangestothePricecolumnthatviolatecompanypolicy.

B.CreateastoredprocedurethatdisallowschangestothePricecolumnthatviolatecompanypolicy.

C.OnthePricecolumn，createacheckconstraintthatrequiresaspecifiedminimumvalue.

D.OnthePricecolumn，createaforeignkeyconstrainttoatablethatcontainsvalidprices.

andSQL2.SQL1islocatedonthelocalnetwork.SQL2islocatedatavendorssiteandisconnectedbyusingaVPNovertheInternet.YouneedtowriteheterogeneousqueriesonSQL1thataccessdatafrombothSQL1andSQL2.Toensurethatyourqueriesarefunctional，youmustconfigureaccesstothevendorssite.Whatshouldyoudo？（）

A.ConfigureanHTTPendpointforSQL2onSQL1.

B.ConfigureSQL2asalinkedserveronSQL1.

C.ConfigureanHTTPendpointforSQL1onSQL2.

D.ConfigureSQL1asalinkedserveronSQL2.

ht，dataisimportedintoadatabase，andthedatabaseisthensettoberead-only.Duringbusinesshours，usersrunpredefinedandadhocqueries.Youneedtomonitortheserversperformanceduringtheday.Whataretwopossiblewaystoachievethisgoal？（）

A.UsetheLockWaits/secperformancecounter.

B.UsetheNumberofDeadlocks/secperformancecounter.

C.UsetheTransactions/secperformancecounter.

D.UsetheFullScans/secperformancecounter.

E.UsetheBatches/secperformancecounter.

ortingServices.ReportingServicesisusedtoproducehundredsofreportseachday.YoudiscoverthattheReportServerTempDBdatabaseisgrowing.YouneedtominimizethesizeoftheReportServerTempDBdatabase.Whatshouldyoudo？（）

A.Decreasethetimebetweentransactionlogbackupsofthedatabase.

B.Deletereportsnapshothistoryeachweek.

C.Minimizetheuseofsessioncachinginthereports.

D.Minimizetheuseofreportsnapshotsinthereports.

aSQLServer2005databasethatenablesbusinessuserstorunbothadhocandpredefinedqueries.Yoususpectthatsomequeriesconsumeanexcessiveamountofserverresources.Youneedtoidentifywhichqueriesconsumethemostresources.Youwanttoachievethisgoalasquicklyaspossible.Whatshouldyoudo？（）

A.UsetheDBCCINPUTBUFFERcommand.

B.Usethesys.dm_exec_query_statsdynamicmanagementview（DMV）.

C.Usethesqldiagutility.

D.UsetheSHOWPLANsessionoption.

QLServerlogshipping.Logshippingoccursevery30minutes.Eachnight，afullbackupismadeofthedatabase，andalldatabaseindexesarerebuilt.Thecompany’snetworkadministratorreportsthatSQL1snetworkutilizationbecomesexcessiveafterthenightlymaintenancetasksarecomplete.YouneedtoreducethenetworkbandwidthutilizationforSQL1.Whatshouldyoudo？（）

A.Configurethedatabasetousethebulk-loggedrecoverymodel.

B.Eachnight，rebuildonlythoseindexesthatrequireit.

C.Disablelogshippingbeforethenightlymaintenance.Re-enablelogshippingafternightlymaintenancecompletes.

D.Increasethetimebetweentransactionlogbackups.

Youareadatabaseadministratorforyourcompany.Eachnight，youperformfullbackupsofyourSQLServer2005computer.Duringbusinesshours，youperformhourlytransactionlogbackups.Yourebuilddatabaseindexeseachnight.Youneedtomodifyyourbackupstrategy.Youmustensurethatthedatabaserecoverstoanewserverasquicklyaspossible.Whatshouldyoudo？（）

A.Schedulethefullbackupstorunafterthenightlyindexisrebuilt.

B.Schedulethefullbackuptorunbeforethenightlyindexisrebuilt.Scheduleadifferentialbackuptorunafterthenightlyindexisrebuilt.

C.Scheduleanadditionaltransactionlogbackuptorunafterthenightlyindexisrebuilt.

D.Scheduleamarkertobeaddedtothetransactionlogbeforethenightlyindexisrebuilt.