2023年微軟認(rèn)證筆試歷年全考點試卷附帶答案

長風(fēng)破浪會有時，直掛云帆濟(jì)滄海。住在富人區(qū)的她2023年微軟認(rèn)證筆試歷年全考點試卷附帶答案第1卷一.單選題(共10題)1.YouaretheadministratorofaWindowsNTServer4.0computernamedEzonexam1.Ezonexam1isabackupdomaincontroller(BDC),andamemberofE'sWindows2000ActiveDirectorydomain.Ezonexam1containsfiveharddisks.Disk0and1areconfiguredasaWindowsNT4.0mirrorset.Themirrorsetcontainstheoperatingsystemfilesand500MBoffreediskspace.Disk2,3and4areconfiguredasaWindowsNT4.0stripesetwithparityandcontainemployeedatafiles.TheWindowsNT4.0stripesetwithparityhasamaximumcapacityof140GBandcontains15GBoffreediskspace.A.Ezonexam1runsanapplicationthatisusedby400companyemployees.Anewversionoftheapplicationisavailable.Youneedtoinstallthenewversion,butitrequiresWindows2000Server.Also,theapplicationwillnotrunonadomaincontroller.B.YouneedtoinstallthenewapplicationonEzonexam1asquicklyaspossible.Whatshouldyoudofirst?C.OnEzonexam1,backuptheemployeedatafiles.Thenformatallfivedisksandperform.acleaninstallationofWindows2000Server.Restoretheemployeedatafiles.D.OnEzonexam1,installWindows2000Server.ConfigureEzonexam1touseadual-bootconfigurationthatincludesWindowsNTServer4.0andWindows2000Server.E.UpgradeEzonexam1toWindows2000Server.Duringtheupgrade,selecttheoptiontomakeEzonexam1amemberserver.F.UpgradeEzonexam1toWindows2000Server.Duringtheupgrade,selecttheoptiontomakeEzonexam1adomaincontroller.Aftertheupgradeiscomplete,demoteEzonexam1.請看正確答案：FUpgradeEzonexam1toWindows2000Server.Duringtheupgrade,selecttheoptiontomakeEzonexam1adomaincontroller.Aftertheupgradeiscomplete,demoteEzonexam1.解析：解析：Explanation:WeupgradeEzonexam1.WehavenochoicethattheupgradedWindows2000Serverwillbeadomaincontroller.Wearethenabletousethedcpromo.exeutilitytoremovetheActiveDirectoryanddemotetheDomaincontrollertoamemberserver.2.YouaretheadministratorofanetworkthatconsistsofWindows2000ServerComputersandWindows2000Professionalcomputers.YouwanttoconfigurethedeploymentofthemostrecentWindows2000ServicepacksothatusersoftheWindows2000ProfessionalComputersreceivetheservicepackautomaticallywhentheylogontothedomain.A.Whatshouldyoudo?B.CreateaMicrosoftWindowsinstallerpackagefortheservicepack.ConfigureRIStousethepackage.C.CreateaMicrosoftWindowsinstallerpackagefortheservicepack.Configurethepackageinagrouppolicy.D.CreateaMicrosoftWindowsinstallerpackagefortheservicepack.Configurethepackageinthelocalcomputerpolicy.E.Placetheservicepackinadistributedfilesystem(Dfs).請看正確答案：CCreateaMicrosoftWindowsinstallerpackagefortheservicepack.Configurethepackageinagrouppolicy.解析：解析：Explanation:TodeploythemostrecentWindows2000ServicepacksothatusersoftheWindows2000Professionalcomputersreceivetheservicepackautomaticallywhentheylogontothedomain,wemustcreateanduseaWindowsInstallerpackageandapplyitthroughaGroupPolicy.Incorrectanswers:A:Windowsinstallerpackagesshouldbedeployedbygrouppolicies.RIS,RemoteInstallationServices,isusedtoremotelyinstallWindows2000Professional.C:Ifwedeploytheinstallerpackagewithalocalpolicywewouldhavetomanuallyconfigurethepolicyonallclients.ThiscouldrequireconsiderableadministrativeeffortD:DFSisusedtoorganizenetworkfolders,nottodeployupdatesofapplications.3.YouaretheadministratorofanetworkthatincludesWindowsNTServer4.0computers,WindowsNTWorkstation4.0computers,andUNIXcomputers.ThenetworkconsistsofasingleWindowsNTdomain.YouareupgradingaWindowsNTServercomputernamedServer1toWindows2000Server.Server1isaBDCinthedomain.TheexistingDNSserverisaUNIXcomputerthatsupportsSRV(service)recordsandisconfiguredtoacceptdynamicupdates.TheexistingWINSserverisanotherWindowsNTServercomputer.A.YouwanttoconfigureServer1asadomaincontrollerinaNewActiveDirectoryforest.YouwanttheexistingWindowsNTdomainaccountstobeupgradedtoActiveDirectory.YouplantoupgradetheotherdomaincontrollersinthedomaintoWindows2000aftertheupgradeofServer1iscomplete.B.Youwanttoperform.theupgradeofServer1withtheleastpossibleimpactonothercomputersonthenetwork.Whatshouldyoudo?C.PromoteServer1tothePDCofthedomain.RunWindows2000SetuponServer1.D.RunWindows2000SetuponServer1.AttheendofSetup,configureServer1asaDNSserverandaWINSserver.E.AddastaticmappingforServer1ontheWINSserver.OntheDNSserver,createanSRVrecordfortheLDAPserviceonServer1.RunWindows2000SetuponServer1.F.InstalltheMicrosoftDNSserviceonanexistingWindowsNTserver.ApplyWindowsNT4.0servicepack4orlatertotheserver.RunWindows2000SetuponServer1.請看正確答案：CPromoteServer1tothePDCofthedomain.RunWindows2000SetuponServer1.解析：解析：Explanation:WewanttoupgradetheNTdomaintoanActiveDirectorydomain;particularlywewanttomigratetheNTuseraccounts.Firstweneedtopromoteserver1toPDCsinceitcontainsthemastercopyofdomaininformation-SAM.ThenupgradethePDCtoWindows2000Server.ActiveDirectoryrequiresaDNSserverthatsupportsSRV(servicerecords).TheUNIXDNSserversupportsthis.4.YouaretheadministratorofaSQLServer2000computernamedSQL1.Youwanttoperform.adhocdistributionqueriesagainstadatabasethatisstoredonaSQLServer2000computernamedSQL2.SQL2containsseveraldatabases,andeachofthesedatabasesusesadifferentcollation.Youwanttoensurethatcomparisonsindistributedqueriesareevaluatedcorrectly.Youalsowanttominimizeadministrativeoverhead.A.HowshouldyouconfigureSQL1?B.UsetheALTERDATABASEstatementtochangethecollationofthedatabasesonSQL1.C.AddSQL2asremoteserver.D.AddSQL2asalinkedserver.SelecttheUseRemoteCollationcheckbox,anddonotspecifyacollationname.E.AddSQL2asalinkedserver.SelecttheUseRemoteCollationcheckbox,andspecifyacollationname.RepeatthisprocessonceforeachdatabaseonSQL2.請看正確答案：DAddSQL2asalinkedserver.SelecttheUseRemoteCollationcheckbox,anddonotspecifyacollationname.解析：解析：Explanation:WeshouldsetupSQL2asalinkedserver.Thiswouldenabletoissuedistributedqueriestoit.WeshouldalsoselectRemoteCollationoptiontousethecollationontheremoteserver.Note:SQLServer2000allowsthecreationoflinkstoOLEDBdatasourcescalledlinkedservers.AfteralinkhasbeencreateditispossibletoreferencerowsetsfromtheOLEDBdatasourcesastablesinTransact-SQLstatementsandpasscommandstotheOLEDBdatasourcesandincludetheresultingrowsetsastablesinTransact-SQLstatements.Eachdistributedquerycanreferencemultiplelinkedserversandcanperform.eitherupdateorreadoperationsagainsteachindividuallinkedserver.Asingledistributedquerycanperform.readoperationsagainstsomelinkedserversandupdateoperationsagainstotherlinkedservers.Thelinkedserveroptionsdefinedbyusingthesp_serveroptionstoredprocedurecontrolhowSQLServerusescollationsfromlinkedservers.WhentheUseRemoteCollationoptionissettoTRUE,itspecifiesthatthecollationofremotecolumnsisusedforSQLServerdatasources,andthecollationspecifiedinCollationNameisusedfordatasourcesotherthanSQLServer.WhenFALSE,distributedqueriesalwaysusethedefaultcollationofthelocalserverinstance,andCollationNameandthecollationofremotecolumnsareignored.IftheUseRemoteCollationoptionissettoTRUE,wecanspecifythenameofthecollationusedbytheremotedatasourceintheCollationNameoption.Thecollationmust,however,besupportedbySQLServer.ThisoptionshouldbeusedwhenaccessinganOLEDBdatasourceotherthanSQLServer,butwhosecollationmatchesoneoftheSQLServercollationsIncorrectAnswers:A:TheCOLLATEclauseoftheALTERDATABASEstatementcanbeusedtochangethecollationusedbythedatabase.However,thissolutionisinappropriateastheSQL2servercontainsseveraldatabases,eachofwhichusesadifferentcollation.Wewouldthusnotbeabletospecifyallthecollations.B:Remoteserversaresetupinpairswithbothserversconfiguredtorecognizeeachotherasremoteservers.TheconfigurationoptionsforbothserversshouldbesetsothateachinstanceofSQLServerallowsremoteuserstoexecuteprocedurecalls.However,supportforremoteserversisprovidedforbackwardcompatibilityonly.ApplicationsthatmustexecuteproceduresagainstremoteinstancesofSQLServer2000shoulduselinkedserversinstead.D:InthisscenariowecannotspecifythecollationnameasSQL2containsseveraldatabases,eachofwhichuseadifferentcollation.5.Ezonexamhas50offices.TheemployeesintheseofficeshavelimitedknowledgeofWindows2000.Eachofficehasanetworkofbetweenfiveand20clientcomputers.Theofficenetworksareconnectedtoeachother.Thecompanyisbuying50identicalcomputerstorunWindows2000Serverintheseoffices.Theservermustbeinstalledtothecompany'sstandardconfiguration.YouuseSetupManagertocreateanetworkshareddistributionfolderandaUnattend.txtfilethatspecifiesthecompany'sstandardconfiguration.Youwanttoautomatetheinstallationprocessasmuchaspossible,intheleastpossibleamountoftime.A.Whatshouldyoudo?B.RunMakebt32.exetocreatefourinstallationstartupdisksandaddtheUnattend.txtfiletothefirstdisk.Instructanemployeeateachofficetostarttheinstallationbyusingthesedisks.C.CreateaMicrosoftMS-DOSnetworkbootdiskthatmakesaconnectiontothenetworkshareddistributionfolderandrunsthewinntcommandwiththe/sand/uswitches.Instructanemployeeateachofficetostarttheinstallationbyusingthisdisk.D.CreateafloppydiskthatcontainsonlytheUnattend.txtfile.InstructanemployeeateachofficetostarttheinstallationbyusingtheWindows2000Servercompactdisc,withthefloppydiskinserted.E.CreateaWindows2000folderonaharddisk.CopytheWindows2000Servercompactdisctothefolder.AddtheUnattend.txtfiletothefolder.CopythefoldertoawriteableCInstructanemployeeateachofficetostarttheinstallationbysuingthisC請看正確答案：CCreateaMicrosoftMS-DOSnetworkbootdiskthatmakesaconnectiontothenetworkshareddistributionfolderandrunsthewinntcommandwiththe/sand/uswitches.Instructanemployeeateachofficetostarttheinstallationbyusingthisdisk.解析：解析：Explanation:Winntandnotwinnt32asthebootdisksoperateinDOSmodeandworkswith16-bitapplications.The/s:pathswitchspecifiesthelocationoftheinstallationfilesforWindows2000Server.The/u:fileswitchspecifiesthelocationoftheanswerfileforunattendedinstallationsandthenumberofsecondstowaitbetweencopyingthefilesandrestartingthecomputer.SincetheemployeeshavelimitedknowledgeinsofarasWindows2000isconcerned,itwouldbebesttomakeuseofthewinntcommand-linewiththeabovementionedswitches.Incorrectanswers:A:ThisoptionpresupposesthattheemployeeswhowillbetaskedwiththeinstallationhaveasoundknowledgeofWindows2000.C,D:ThisoptionwouldbeproblematicsincetheemployeeshavelimitedknowledgewhenitcomestoWindows2000.6.YouarethenetworkadministratorforEzonexam.Youareplanningtoupgrade35WindowsNTServer4.0computerstoWindows2000Server.Youwanttoaccomplishtheupgradesbyusingadistributionserver.TheWindowsNTServer4.0computerssupportatightproductionschedulethatrequiresthemtobeonlinefrom8:00A.M.tomidnight,sevendaysaweek.Youscheduletheupgradetorunduringnon-businesshours.Becauseofthelimitedamountoftimetheupgradesmustbeperformedasquicklyaspossible.Youwanttocompletetheupgradesbeforeproductionbeginsinthemorning.B.Whatshouldyoudo?C.Perform.anunattendedinstallationbyrunningthewinnt32commandandthe/cmdconsswitch.D.Perform.anunattendedinstallationbyrunningthewinnt32commandandspecifytheuseofa.txtfileandauniquenessdatabasefile.E.Perform.anunattendedinstallationbyrunningthewinntcommandandspecifytheuseofa.txtfileandauniquenessdatabasefile.F.Perform.anunattendedinstallationbyusingaWinnt.siffilewithacommandssectionthatinitiatestheUpdate.execommandinquietmode.請看正確答案：DPerform.anunattendedinstallationbyrunningthewinnt32commandandspecifytheuseofa.txtfileandauniquenessdatabasefile.解析：解析：Explanation:Performinganunattendedinstallationfromadistributionserverwillworksincetheupgrademustbedoneinnon-businesshours.7.YouwanttoinstallWindows2000Professionalon45newcomputersonyourcompany'snetwork.YoufirstinstallWindows2000Professionalononeofthenewcomputers.YoulogontothecomputerbyusingthelocalAdministratoraccount.YouinstallMicrosoftOffice97,avirusscanner,andothercompany-standardapplications.YouthencreateaRISimageofthecomputeryouconfigured.A.YouwanttoconfiguretheRISimagesothatthestandardapplicationswillbeaccessibletotheuserwhentheuserfirstlogsontothenetwork.Whatshouldyoudo?B.RunRbfg.exebeforeinstallingthestandardapplications.C.RunRIPrep.exebeforeinstallingthestandardapplications.D.CopytheAllUsersprofiletotheDefaultUsersprofile.E.CopythelocalAdministratoraccountprofiletotheDefaultUsersprofile請看正確答案：ECopythelocalAdministratoraccountprofiletotheDefaultUsersprofile解析：解析：Explanation:BycopyingthelocalAdministratoraccountprofiletothedefaultusersprofile,alluserswillgetaccesstotheshortcuts,whichweremadewhenthelocaladministratorinstalledtheapplications.8.YouaretheadministratorofEzonexam'snetwork.YouwanttodeployaWindows2000Professionalservicepackto10computersintheDevelopmentorganizationalunit.YoucreateaWindows2000installerpackagefilefortheservicepack.Youusethepackagefiletosuccessfullyinstalltheservicepacktoothercomputersinthedomain.YouassignthepackagefiletotheDevelopmentorganizationalunit.Aftertheinstallation,younoticethattheservicepackwasnotinstalledonanyofthe10computers.A.YouwanttoensurethattheservicepackissuccessfullyinstalledonthecomputersintheDevelopmentorganizationalunit.Whatshouldyoudo?B.UseComputerManagementtostarttheWindowsinstallerserviceonallthecomputersintheDevelopmentorganizationalunitC.UsethelocaladministratoraccounttologontothecomputersintheDevelopmentorganizationalunit.ThenredeploytheservicepacktothecomputersintheDevelopmentorganizationalunit.D.RunWindowsInstallertorepairthepackagefile.ThenredeploytheservicepacktothecomputersintheDevelopmentorganizationalunit.E.AddtheuseraccountsfromtheDevelopmentorganizationalunittoaDACL.Granttheuseraccountsreadpermissiontotheservicepackdeploymentdirectory.請看正確答案：EAddtheuseraccountsfromtheDevelopmentorganizationalunittoaDACL.Granttheuseraccountsreadpermissiontotheservicepackdeploymentdirectory.解析：解析：Explanation:BeforeuserscanaccessresourcesonWindows2000,theymustbeassignedtheappropriatepermissionstothoseresources.InthisscenariotheusersfromtheDevelopmentOUneedtobeassignedreadpermissiontothedeploymentdirectory,whichisanobject,tobeabletostarttheinstallationprocess.Objects,suchasthedeploymentdirectory,useaDACL(discretionaryaccesscontrollist)tocheckwhetherusersorgroupshavebeenallowedordeniedpermissionstotheobjectthattheyareattemptingtoaccess.Therefore,theuseraccountsoftheDevelopmentOUmustbeaddedtotheDACLofthedeploymentfolder.9.YouneedtoinstallWindows2000Professionalon300computersforacustomercompanycalledEzonexam.Thecomputershavedifferentmanufacturersanddifferenthardwareabstractionlayers(HALs).YouplantouseaWindows2000ServercomputerrunningRemoteInstallationServices(RIS)toperform.theinstallation.Aftertheinstallationiscompleteforthefirst25computers,usersofthosecomputersreportproblems.YoudiscoverthatthelatestWindows2000servicepackresolvesthoseproblems.A.Youwanttoapplytheservicepacktotheremaining275computersduringtheinstallation.Whatshouldyoudo?B.InstalltheservicepackonareferenceWindows2000Professionalcomputer,andthenruntheRiprepcommandonthatcomputer.UsetheresultingimageforRIS.C.InstalltheservicepackontheRISserver,andthenruntheRiprepcommandonthatserver.UsetheresultingimageforRIS.D.CopytheservicepacktotheCD-basedimagesharedfolderusedbyRIS.E.Slipstreamtheservicepackintoanewi386distributionsharedfolder,andthenruntheRisetupcommandtocreateanewCD-basedimagefortheRISserver.請看正確答案：ESlipstreamtheservicepackintoanewi386distributionsharedfolder,andthenruntheRisetupcommandtocreateanewCD-basedimagefortheRISserver.解析：解析：Explanation:YoucanuseRisetup.exetocreateaCD-ROM-basedRISimagewithaservicepackslipstreamed.Thisistheprocedure:1.CopythecontentsoftheWindows2000ProfessionalCD-ROMtoasharedfolderonaserver(oralocalfolderontheRISserver).2.FromtheWindows2000servicepacksourcefiles,runtheupdate-s:foldercommandtoslipstreamthesourcefileswiththeservicepack.3.Whentheslipstreamingprocessisfinished,runRisetup.exeontheRISservertoaddanewimagetotheserver.Whenyouarepromptedforthelocationofthefiles,typethepathtotheslipstreamedshareyoucreatedinsteps1and2.IncorrectAnswersA:Thisproposedsolutionwouldnotworkbecausethecomputershavedifferenthardware.Forthisreason,wemustuseaCD-basedimage.B:WearegoingtoinstallWindows2000Professionalcomputers;wecannotuseaRISimageofaWindows2000ServercomputerC:JustcopyingtheServicePacktotheCD-basedimagesharedfolderwouldnotapplyit.10.YouaretheadministratoroftwoSQLServer2000computers.Oneoftheseserverscontainsa4-GBdatabasenamedmarketing.Youwanttoremovethemarketingdatabasefromoneserverandaddittotheotherasquicklyaspossible.Whatshouldyoudo?A.Detachthedatabasefromtheoriginalserverbyusingthesp_detach_dbstoredprocedure.Copythedatabaseandthetransactionlogfilestothenewserver,andattachthembyusingthesp_attach_dbstoredprocedure.B.UsetheDTSexportwizardtotransferalldatabaseobjectsfromtheoriginalservertothenewserver.Dropthedatabasefromtheoriginalserver.C.Runafullbackupofthedatabaseontheoriginalserver.Createanewdatabasenamedmarketingonthenewserver.Restorethebackupinthenewmarketingdatabase.Dropthedatabasefromtheoriginalserver.D.Shutdowntheoriginalserver.Copythedatabaseandthetransactionlogfilestothenewserver.UsetheDISKINITandDISKREFITstatementstoattachthedatafiletothenewserver.Dropthedatabasefromtheoriginalserver.請看正確答案：ADetachthedatabasefromtheoriginalserverbyusingthesp_detach_dbstoredprocedure.Copythedatabaseandthetransactionlogfilestothenewserver,andattachthembyusingthesp_attach_dbstoredprocedure.解析：解析：Explanation:Detachingandattachingdatabasesissometimesausefultechniqueforquicklymovingadatabasefromonecomputertoanother.Tomoveadatabase,ordatabasefile,toanotherserverordiskthedatabasemustfirstbedetachedfromtheoriginalserverordisk;movedtotheotherserverordiskandthenattachedontheserverordisk.Inadditionthenewlocationofthemovedfile(s)mustbespecified.Thesp_detach_dbstoredprocedureisusedtodetachthedatabaseandcanrunUPDATESTATISTICSonalltablesbeforedetachingthedatabasewhilethesp_attach_dbstoredprocedureisusedtoattachthedatabaseinitsnewlocation.IncorrectAnswers:B:DTScanimportdatafromatextfileorfromanOLEDBdatasourcesuchasaMicrosoftAccess2000databaseintoSQLServer.ItcanalsoexportdatafromSQLServertoanOLEDBdatadestination.Itprovidesforhigh-speeddataloadingfromtextfilesintoSQLServertables.However,itisnotthefastestwaytomoveawholedatabasefromoneservertoanother.C:Beforeadatabasecanberestoredfromabackuptoanewlocation;thedatabasemustfirstberecreatedinthedestinationasthebackupholdsonlythedatafilesthatbelonginthevarioustables.Itdoesnotholdthetabledefinitions.Thisisnotthefastestmethodtomoveadatabase.D:TheDISKINITandDISKREFITcommandscannotbeusedtomoveadatabasefromoneservertoanother.Note:DISKINITandDISKREINITarefeaturesthatareusedinaSQLServer6.x.inSQLServer6.x,DISKINITisusedtocreatedatabaseortransactionlogdevicestostorethespecifieddatabaseortransactionlogwhenDISKINITfollowedeitheraCREATEDATABASEorALTERDATABASEstatementwhileDISKREINITisusedtorestoredeviceentriestoappropriatesystemtableswhenthedeviceentrywasmissingfromsysdevices.InSQLServer2000theCREATEDATABASEandALTERDATABASEstatementsallowforthecreationofseparatedataandlogfiles.BothCREATEDATABASEandALTERDATABASEcreateoperatingsystemfilesanddatabasesinasinglestep.ItisthusrecommendedthatallreferencestoDISKINITshouldberemovedinSQLServer2000andreplacedwithreferencestoeitherCREATEDATABASEorALTERDATABASE.二.多選題(共10題)1.YouneedtoinstallWindows2000ServerononeofyourolderWindowsNTServer4.0computers.Theserverhasdualprocessors,2GBofRAM,aRAIDcontrollerwithfiveSCSIharddisksinanarray,andageneric10/100-MBnetworkadapter.YoubegintheserverinstallationbyupdatingtheSCSIfirmware.YouthenstarttheinstallationoftheWindows2000Serveroperatingsystem.Duringthenextportionoftheinstallation,youreceiveanerrormessageindicatingthatnoharddiskscanbefound.A.YouwanttosuccessfullyinstallWindows2000Serveronthecomputer.B.Whatshouldyoudo?(Eachcorrectanswerpresentspartofthesolution.Choosetwo)C.RestarttheinstallationbyusingtheWindows2000InstallationCD-ROM.PressF3duringthetext-modesetup.D.RestarttheinstallationbyusingtheWindows2000InstallationCD-ROM.PressF6duringthetext-modesetup.E.RestarttheinstallationbyusingaMS-DOSbootdiskwithaCD-ROMdriver.F.InsertadiskwiththeoriginalSCSIfirmware.G.InsertadiskwiththeOEMSCSIdriver.請看正確答案：DGRestarttheinstallationbyusingtheWindows2000InstallationCD-ROM.PressF6duringthetext-modesetup.InsertadiskwiththeOEMSCSIdriver.解析：解析：Answer:B,E2.YouaretheadministratorofaSQLServer2000computer.TheservercontainsaDataTransformationServices(DTS)packagethatqueriesmultipledatabasesandwritestheresultstoatextfile.YourunthispackagebyusingaMicrosoftWindowsbatchfile.ThebatchfileusesthedtsrunutilitytoexecutetheDTSpackage.Youwanttoensurethatconnectionproperties,suchasloginnamesandpasswords,cannotbereadormodifiedbyusers.Whichtwoactionsshouldyoutake?(Eachcorrectanswerrepresentspartofthesolution.Choosetwo.)A.SavetheDTSpackagesothatithasanownerpassword.B.SavetheDTSpackagesothatithasauserpassword.C.EncrypttheDTSpackagedetailsinthecommandlineofthedtsrunutility.D.StoretheDTSpackageintheMeta.DataServicesrepository.E.StoretheDTSpackageasaMicrosoftVisualBasicfile.請看正確答案：ACSavetheDTSpackagesothatithasanownerpassword.EncrypttheDTSpackagedetailsinthecommandlineofthedtsrunutility.解析：解析：Explanation:Inthisscenariowewilluseawindowsbatchfilewiththeownerpasswordformaximumsecurity.3.YouwanttoupgradeaWindowsNTServer4.0computernamedServer34toWindows2000Server.Server34isamemberserverinaWindows2000domainnamedmarketing.fabrikam.local.Thedomainrunsinnativemode.YouwanttochangetheroleofServer34fromamemberservertoadomaincontrollerinthesamedomain.Whatshouldyoudo?(ChooseTwo)A.ReinstallWindowsNTServer4.0onServer34inthesameWINNTfolder,andmakeServer34aBB.DC.inthemarketingdomain.D.UseServerManageronServer34andpromoteServer34toaPDCforthemarketingdomain.請看正確答案：BCDinthemarketingdomain.解析：解析：Explanation:ToupgradeaWindowsNT4.0memberservertoaWindows2000DomainControllerwemustfirstupgradetheWindowsNT4.0memberservertoWindows2000ServerandtheninstallActiveDirectoryServicesthroughtheActiveDirectoryInstallationWizard,whichcanbestartedwiththeDCPROMO.EXEcommandorbytheConfigureYourServerutilityinAdministrativetools.4.YouaretheadministratorofaSQLServer2000computer.Yourcompanypurchasedanaccountingapplicationfromavendor.TheapplicationstoresitsdatainadatabasenamedAccountingontheserver.Thetablesinthisdatabasecontaincolumnsthatfunctionasprimarykeys,butPRIMARYKEYandFOREIGNKEYconstraintsarenotused.YouneedtoreplicatedatafromthisdatabasetoanotherSQLServercomputer.Thisserverwillusethereplicateddatatogeneratereports.Mostreportswillruneachmonth,buttheaccountingdepartmentneedstohavetheabilitytorunreportsatanytime.Reportsshouldbeaccuratethroughthelastfullworkingday.A.Youcannotmakeanychangestothedatabase,butyouneedtoimplementreplication.Whichtwoactionsshouldyoutake?(Eachcorrectanswerpresentspartofthesolution.Choosetwo)B.Implementmergereplication.C.Implementsnapshotreplication.D.Implementtransactionalreplication.E.Schedulereplicationtoruncontinuously.F.Schedulereplicationtorunduringoff-peakhours.請看正確答案：CFImplementsnapshotreplication.Schedulereplicationtorunduringoff-peakhours.解析：解析：Explanation:5.ThenetworkconsistsofasingledomainnamedEthatincludes20WindowsNTworkstation4.0clientcomputers.AllotherclientcomputersareWindows2000Professionalcomputers.YouinstallTerminalServicesononeoftheWindowsServercomputersandTerminalServicesClientonthe20WindowsNTWorkstation4.0clientcomputers.Youcreateasystempolicyontheserverthatisconfiguredastheterminalserver.ThissystempolicydeniesaccesstoNetworkNeighborhood.YoufindthattheusersoftheterminalservercanstillbrowsethenetworkwhentheyopenMyNetworkPlacesfromWindows2000ProfessionalcomputerorwhentheyopenNetworkNeighborhoodfromWindowsNTWorkstation4.0computers.Youwanttopreventallusersfrombrowsingthenetwork.A.Whatshouldyoudo?(Eachcorrectanswerpresentsacompletesolution.Choosetwo.)B.CreateaWindowsGroupPolicythatdeniesuseraccesstoMyNetworkPlaces.C.CopytheWindowsNTpolicyfiletothe20WindowsNTWorkstation4.0computers.D.CreateaWindowsNT4.0defaultuserpolicyontheWindows2000ServercomputerthatisconfiguredasthePDCemulator.E.ModifytheWindowsNTpolicytemplatefilesothatyoucanrestrictaccesstobothMyNetworkPlacesandNetworkNeighborhood.Savethepolicyfileontheterminalserver.F.ConfiguretheterminalservertouseApplicationservermode.SelectthePermissionscompatiblewithTerminalServer4.0Usersoption.請看正確答