A．培养法B．MSBB法C．Dentocult-LB试验D．刃天青纸片法E．乳胶凝集试验 属于免疫学方法检测菌斑内变

requiretheminimumamountofadministrativeeffort.Theauthenticationenvironmentmustfulfillthecompany’ssecurityrequirements.Whatshouldyoudo？（）

A.CreateaSQLServerloginwithWindowsAuthenticationforeachmainofficedatabaseadministrator.Addalloftheseloginstothedb_ownerroleineachdatabase.

B.CreateaSQLServerloginwithSQLServerAuthenticationforeachmainofficedatabaseadministrator.Addalloftheseloginstothesysadminrole.

C.CreateaWindowsglobalgroupnamedDBAdmins.Addeachmainofficedatabaseadministrator’s WindowsuseraccounttotheWindowsDBAdminsgroup.CreateaSQLServerloginwithWindowsAuthenticationforthegroup.Addthegrouptotheserveradminfixedserverrole.

D.Addeachmainofficedatabaseadministrator’sWindowsuseraccounttotheWindowsSQLManagersgroup.

nerror.Youinvestigatetheerror.Youdiscoverthatinoneofthedatabases,adeveloperhasaccidentallydeletedsomedatainatablethatiscriticalfortransactionprocessing.Thedatabaseusesthefullrecoverymodel.Youneedtorestorethetable.Youneedtoachievethisgoalwithoutaffectingtheavailabilityofotherdatainthedatabase.Whatshouldyoudo?（）

A.Backupthecurrenttransactionlog.Restorethedatabasewithadifferentnameandstopatthepointjustbeforethedataloss.Copythetablebackintotheoriginaldatabase.

B.Backupthecurrenttransactionlog.Restorethedatabasetothepointjustbeforethedataloss.

C.Restorethedatabasefromtheexistingbackupfilestoatimejustbeforethedataloss.

D.Restorethedatabasetothepointofthelastfullbackup.

ntheupgrade,youupgradethedevelopmentdatabaseservers.Youneedtoverifythattheupgradeofthedatabaseserversdidnotintroduceanyerrorsintothedatabases.Whatshouldyoudo?（）

A.Executeunittestscriptsforeachstoredprocedureineachdatabase.

B.ExecutethestoredproceduresintheSQLServerManagementStudiodebugger,andverifytheresults.

C.Setthedatabasecompatibilitylevelonthedatabaseserversto80.

D.Executetheapplicationuserinterfacetestscriptstoverifyproperoperation.

A.Createanewchilddomainnamedhr.ad.margiestravel.comintheexistingforest.MovetheresourcesfromtheHROUtothisnewdomain.AddtheappropriatesecuritysettingsintheDefaultDomainPolicyforthisnewdomain.

B.AddtheappropriatesecuritysettingstothecurrentDefaultDomainPolicy.

C.AddtheappropriatesecuritysettingstothelocalsecuritypolicyofSQL1.

D.SettheSQLservercheck_policyandcheck_expirationoptionstoOnwhencreatingalluseraccounts.

A.CreateaSQLServerReportingServices（SSRS）report.EnablecustomerstomodifythereportbyusingReportBuilder.

B.CreateanASP.NETapplicationthatwillenablecustomerstoviewandmodifyreportsbycallingtheSQLServerReportingServices（SSRS）API.

C.CreateanASP.NETapplicationthatwillenablecustomerstoviewandmodifyreportsbyusingaSQLServerReportingServices（SSRS）ActiveXcontrol.

D.CreateaSQLServerReportingServices（SSRS）ReportModel.EnablecustomerstomodifyreportsbasedonthemodelbyusingReportBuilder.

A.CreateanHTTPendpointwithNTLMauthentication，andcreateaserviceprincipalname（SPN）.

B.CreateanHTTPendpointwithdigestauthentication，andcreateaserviceprincipalname（SPN）.

C.CreateanHTTPendpointwithintegratedauthentication，andcreateaserviceprincipalname（SPN）.

D.CreateanHTTPendpointwithKerberosauthentication.

requiresthateachserveruseafirewall.YoufindthatyoucanconnecttotheSQLServerinstancefromthelocalcomputer.However,clientcomputerscannotconnecttotheSQLServerinstance.Youneedtoidentifythemostlikelycauseoftheconnectionissues.Whatshouldyoudofirst?（）

A.Ensurethatport1433isopeninyourfirewall.

B.Ensurethatport443isopeninyourfirewall.

C.EnsurethatclientcomputersconnectbyusingSharedMemoryprotocol.

D.Ensurethattheserverisnotpaused.

A.SettheappropriatelocalpasswordpoliciesforallcomputersonwhichSQLServerisinstalled.

B.SettheserverauthenticationmodeofallSQLServerinstancestoWindowsAuthenticationmode.

C.InstallallinstancesofSQLServer2005oncomputersthatrunWindowsServer2003orlater.

D.CreateSQLServerloginsthathaveCHECK_POLICYenabled.

A.ImportthedataintoastagingtablebyusingtheOPENROWSETBULKstatement.ExecuteaTransact-SQLstoredproceduretocleansethedataandtoinsertthedataintothedatabase.

B.ImportthedataintoastagingtablebyusingtheBULKINSERTstatement.ExecuteaTransact-SQLstoredproceduretocleansethedataandtoinsertthedataintothedatabase.

C.CreateaSQLServerIntegrationServices（SSIS）packagetoimport，standardize，andcleansethedata.

D.CreateaCLRstoredproceduretoimportthedataintoastagingtable，tocleanseandstandardizethedata，andtoinsertthedataintothedatabase.

anyadhocqueriesagainstthecompanydatabases.ErichasaccesstotheCustomerdatabaseonSQL1.HedoesnothaveaccesstotheSalesdatabaseonSQL2.YouneedtoensurethatEriccanwritequeriesthatjoininformationfrombothservers.Whatshouldyoudofirst?（）

A.CreatealinkedserveronSQL1toSQL2.Configurethelinkedservertouseimpersonation.

B.CreatealinkedserveronSQL1toSQL2.Configurethelinkedservertousemappedlogins.

C.InstructErictowritethequeriesonSQL2byusingtheOPENQUERYstatementandspecifyingSQL1astheservername.

D.InstructErictospecifySQLServerobjectnamesbyusingfour-partnotation.