長風破浪會有時，直掛云帆濟滄海。住在富人區(qū)的她2024年微軟認證考試歷年全考點試卷附帶答案第1卷一.單選題(共10題)1.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.2.Youwanttoupgrade400computersfromWindows95toWindows2000Professional.Mostofthecomputersinyourcompanyusethesamehardware.However,severaldifferentperipheraldevicesareusedthroughoutthecompany.YouwanttoverifythatthehardwareinuseiscompatiblewithWindows2000Professional.Youwanttoaccomplishthiswithleastamountofadministrativeeffort.A.Whatshouldyoudo?B.Createseveraldifferentcomputerconfigurations.InstallWindows2000Professionalandenabledriversigning.C.CreateabootablefloppydiskthatcontainsandautomaticallyrunsWinNT32.exe/CheckUpgradeOnlyQ.Sendthefloppydisktoeachuseronthenetwork.D.CopythecontentsofWindows2000ProfessionalCD-ROMtoanetworkshare.Fromthenetwork,modifyyournetworklogonscriptstorunWinNT32.exe/Unattended:ReportOnly.E.UseSetupManagertocreateaSetup.inffile.AddtheentryReportOnly=Yestothe[Win9xUpg]sectionoftheanswerfile.RunWinnt32.exe/Unattended:Snallofthedifferentcomputerconfigurations.請看正確答案：EUseSetupManagertocreateaSetup.inffile.AddtheentryReportOnly=Yestothe[Win9xUpg]sectionoftheanswerfile.RunWinnt32.exe/Unattended:Snallofthedifferentcomputerconfigurations.解析：解析：Explanation:Winnt32.exe/unattended:setup.infwillstartanunattendedinstallationusingtheanswerfilesetup.inf.WhenReportOnly=Yesisaddedinthe[Win9xUpg]sectionoftheanswerfile,theinstallationonlygeneratesanupgradereportandthenexitswithoutmakinganychangestothecurrentWindows95orWindows98installation.TheupgradereportcontainsalistofhardwareandsoftwareincompatibilitiesandissavedtotherootofthesystemdriveiftheSaveReportTokeyisnotspecified.3.YouaretheadministratorofaWindows2000Servernetwork.Oneachserver,youformataseparatesystempartitionandaseparatebootpartitionasNTFS.Severalmonthslater,youshutdownoneoftheserversforthemaintenance.Whenyoutrytorestarttheserver,youreceivethefollowingerrormessage"NTLDRismissing.Pressanykeytorestart".A.YouwanttoinstallanewNTLDRfileontheserver,butyoudonotwanttoloseanysettingsyoumadesincetheoriginalinstallation.Whatshouldyoudo?B.StartthecomputerbyusingtheWindows2000ServerCD-ROMandchoosetorepairtheinstallation.SelecttheRecoveryConsoleandcopytheNTLDRfileontheCD-ROMtotherootofthesystemvolume.C.StartthecomputerbyusingtheWindows2000ServerCD-ROMandchoosetoreinstall.Wheninstallationiscomplete,copytheNTLDRfiletotherootofthebootvolume.D.StartthecomputerbyusingaWindows2000bootablefloppydisk.Fromthecommandprompt,runthesfc/scanbootcommand.E.StartthecomputerbyusingaWindows2000bootablefloppydisk.RuntheFileSignatureVerificationutility.請看正確答案：BStartthecomputerbyusingtheWindows2000ServerCD-ROMandchoosetorepairtheinstallation.SelecttheRecoveryConsoleandcopytheNTLDRfileontheCD-ROMtotherootofthesystemvolume.解析：解析：Explanation:IfthebootsectorcannotfindNTLDR,Windows2000cannotstart.Thiscanbecausedbymoving,renaming,ordeletingNtldr,corruptionofNtldr,orcorruptionofthebootsector.Underthesecircumstances,thecomputermightnotrespondtoinputormightdisplayanerrormessage.TheRecoveryConsolecanbeusedtorestorethentldr.exefile.Thisprocesswouldnotcreateanyothersideeffects.4.YouwanttoupgradeaWindowsNTServer4.0computertoWindows2000Server.ThesystempartitionusestheFATfilesystem.YoustarttheSetupprogrambystartingthecomputerfromtheWindows2000ServerCD-ROM.A.However,youreceivethefollowingerrormessage,"YouchosetoinstallWindows2000onapartitionthatcontainsanotheroperatingsystem.InstallingWindows2000onthispartitionmightcausetheoperatingsystemtofunctionimproperly".B.Youareunabletoperform.theupgrade.Whatshouldyoudotoresolvetheproblem?C.ConvertthesystempartitiontoNTFS.D.DisableAdvancedConfigurationandPowerInterface(ACPI)supportforthecomputer.E.Restartthecomputer,andthenrunWinnt32.exefromtheWindowsNTServer4.0environment.F.RemovetheWindows2000ServerCD-ROMandrestartthecomputerbyusingthesetupfloppydisks.請看正確答案：ERestartthecomputer,andthenrunWinnt32.exefromtheWindowsNTServer4.0environment.解析：解析：Explanation:WhenupgradingearlierversionsofWindowstoWindows2000wemustusewinnt32.exeandmustlaunchitfromwithintheWindowsenvironment.Incorrectanswers:A:Windows2000canbeinstalledorupgradedonadiskorpartitionthatisformattedwiththeFATfilesystem.ThereisthusnoneedtoconvertthefilesystemtoNTFS.B:TheAdvancedConfigurationandPowerInterfaceisusedforpowermanagementanddoesnotaffecttheinstallationorupgradeprocess.ItwouldthusnotbenecessarytodisableACPI.D:ThesetupfloppydisksuseWinnt.exetoinstallWindows2000.WehowevercanonlyusethesetupfloppydiskstoinstallacleancopyofWindows2000onthecomputer.WecannotupgradetheoperatingsystemtoWindows2000usingthesetupfloppydisks.Wemustusewinnt32.exetoupgradeearlierversionsofWindowstoWindows2000.5.YouaretheadministratorofaSQLServer2000computer.Oneofthedatabasesontheservercontainsatablenamedcomplaints.Thistableisusedtostoreinformationaboutcustomercomplaints.Thecustomerservicerepresentativesinyourcompanyaddandedittheinformationinthecomplaintstable.Theyworkwiththistablebyusinganumberofclientapplications,includingaweb-basedapplicationandaMicrosoftWindows32-bitapplication.A.Thecustomerservicemanagerdiscoversthatsomecustomercomplaintsaremarkedasclosedbeforetheyareresolvedtothecustomer’ssatisfaction.B.Youneedtonotifythecustomerservicemanagerwheneveracomplaintismarkedasclosed.Youdonotwanttomakeanychangestotheclientapplications.C.Whatshouldyoudo?D.CreateanUPDATEtriggerthatsendsane-mailmessage.E.Createastoredprocedurethatsendsane-mailmessage.Usethestoredprocedurestomakechangestothedata.F.Createauser-definedfunctionthatsendsane-mailmessage.Usethefunctiontomakechangestothedata.G.Createarulethatvalidatesdataentry.BindtheruletotheCompliantClosedcolumn.請看正確答案：DCreateanUPDATEtriggerthatsendsane-mailmessage.解析：解析：Explanation:AddinganappropriateUPDATEtriggerthatnotifiestheservicemanagerwheneveracomplaintismarkedisclosedwouldaccomplishtherequirements.Theclientapplicationsapplicationwouldnothavetobechanged.6.Youhave17GBofprivatefilesondriveDonyourWindows2000Professionalcomputer.Youhavesharedthefilesasprivate_files.Youdonotwantotheruserstoseethissharenameinthebrowselist.Youwantallothersharenamestocontinuetoappearinthebrowserlist.Whatshouldyoudo?A.Stopthecomputerbrowserservice,anddisablethestartupstate.B.Changethecommentforthesharetohidden:YesC.Changethesharenametoprivate_files$.D.AddahiddenentrytotheHKLMSystem\currentcontrolset\services\larmanserver\shares\private_filesregistryvalueentry.請看正確答案：CChangethesharenametoprivate_files$.解析：解析：Explanation:Byappendingadollarsigntotheendofthesharename,theshareishiddenandthefolderwillnotbeshowninanybrowselist.Onlyuserswhoknowthefoldernamecangainaccesstoitiftheyalsopossesstheproperpermissionstoit.7.YouneedtoinstallWindows2000Professionalon30newcomputers.YoualsoneedtodeployaWindows2000Professionalservicepackduringtheinstallation.First,youcreateanetworkdistributionfoldernamedInstallFiles.Youcopythei386folderfromtheWindows2000ProfessionalCDtotheInstallFilesfolder.A.Whatshouldyoudo?B.CopytheservicepackfilestotheInstallFiles\Miscfolder.C.CopytheservicepackfilestotheInstallFiles\$OEM$folder.D.Fromanexistingclientcomputer,runtheUpdate-ucommandfromtheservicepacktotheInstallFilesfolder.E.Fromanexistingclientcomputer,runtheUpdate-s:InstallFilescommandfromtheservicepacktotheInstallFilesfolder.請看正確答案：EFromanexistingclientcomputer,runtheUpdate-s:InstallFilescommandfromtheservicepacktotheInstallFilesfolder.解析：解析：Explanation:ServicepackslipstreamingreferstoaservicepackbeingintegratedwithanupdatedversionofWindows2000onaCD-ROMoronanetworkshare.WhenWindows2000isinstalledfromeithersource,theappropriatefilesfromtheservicepackareinstalledwithouthavingtomanuallyapplytheservicepackaftertheinstallation.Toapplyanewservicepack,runUpdate.exewiththe-s:distribution_folderswitch,wheredistribution_folderisthenameofthefolderthatcontainstheWindows2000installationfiles.8.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.9.YouaretheadministratorofE'snetwork.Ezonexamhasseveralbranchoffices.EachbranchofficehasaWindows2000ServercomputerwithServicePack2installed.Eachbranchofficealsohasatechnicalsupportdepartment.YouwanttoconfiguretheremoteWindows2000ServercomputerssothatwheneveranewdriverbecomesavailablefromMicrosoft,thebranchofficesarenotifiedautomaticallywhentheadministratorlogsontotheserver.A.Whatshouldyoudo?B.InstallWindowsUpdateC.InstalltheWindows2000ResourceKit.D.ConfigureSystemFileCheckertonotifythebranchoffices.E.ConfigureWindowFileProtectiontonotifythebranchoffices.請看正確答案：BInstallWindowsUpdate解析：解析：Explanation:WindowsUpdateisusedtoupgradethesystemfilesandtoretrieveandapplythelatestservicepacksandpatchesfortheoperatingsystem.AllnecessaryfilesaredownloadedthroughtheInternet.10.YouareupgradingacomputerfromWindows98toWindows2000Professional.Thecomputerisa400-MhzPentiumIII,andhas128MBofRAManda10-GBharddisk.YouareperformingtheinstallationbyusingtheWindows2000ProfessionalCD-ROM.Afterthetextmodeinstallationportioniscomplete,yourestartthecomputer.TheBIOSviruscheckeronyourcomputerindicatesyou'reyourcomputerisinfectedwithaMasterBootRecordvirus.Whatshouldyoudobeforeyoucontinuetheinstallation?A.RemovetheviruscheckerinWindows98.B.DisabletheBIOSviruscheckerandrestartthecomputer.C.RunFixmbr.ExefromtheWindows2000ProfessionalCD-ROM.D.ModifytheBoot.inifiletoincludeasignatureparameterontheARCpathofthesystempartition.請看正確答案：BDisabletheBIOSviruscheckerandrestartthecomputer.解析：解析：Explanation:DuringtheinstallationofWindows2000,thesetupprogrammustmakechangesthebootsector.TheBIOSviruscheckerinterpretschangesmadetothebootsectorastheresultofavirusandpreventsthecomputerfrombootinganyfurther.YoumustthereforedisabletheBIOSviruschecker.二.多選題(共10題)1.YouarethenetworkadministratorforE.Yournetworkhas210Windows2000ProfessionalcomputersandelevenWindows2000Servercomputers.Usersonthenetworksavetheirworkfilesinhomefoldersonanetworkserver.TheNTFSpartitionthatcontainsthehomefoldershasEncryptingFileSystem(EFS)enabled.AusernamedSandraleavesE.Youdecryptthefilesforhermanager.Whenthemanagerattemptstoopenanyofthefiles,hereceivesthefollowingerrormessage:"Accessisdenied."Youwantthemanagertobeabletoaccessthefiles.A.Whatshoulddo?(Eachcorrectanswerpresentsacompletesolution.Choosetwo.)B.MovethefilesfromSandra'sfoldertothemanager'sfolder.C.GrantthemanagerNTFSFullControlpermissiontothefiles.D.Runtheciphercommandtocreateanewfileencryptionkeyforthemanager.E.RuntheciphercommandtogenerateanEFSrecoveryagentkeyandcertificate.F.GrantthemanagerNTFSListFolderContentspermissionstothefoldercontainingSandra'sfiles.請看正確答案：BCMovethefilesfromSandra'sfoldertothemanager'sfolder.GrantthemanagerNTFSFullControlpermissiontothefiles.解析：解析：Explanation:2.YouarethenetworkadministratorforEzonexam.ThenetworkconsistsofasingleActiveDirectorydomainE.AllnetworkserversrunWindowsServer2000.YournetworkincludesasharedfoldernamedEzonexamDocs.Thisfoldermustnotbevisibleinabrowselist.A.However,usersreportthattheycanseeEzonexamDocswhentheybrowseforsharedfolders.B.Howshouldyousolvethisproblem?C.ModifythesharepermissionstoremovetheAll-ReadpermissiononEzonexamDocsfromtheUsersgroup.D.ModifytheNTFSpermissionstoremovetheAllow-ReadpermissionsonEzonexamDocsfromtheUsersgroup.E.ChangethesharenametoEzonexamDocs.F.ChangethesharenametoEzonexamDocs$.請看正確答案：EFChangethesharenametoEzonexamDocs.ChangethesharenametoEzonexamDocs$.解析：解析：Explanation:Appendingadollarsign($)toasharenamehidestheshare.Asharethatisfollowedbyadollarsign($)indicatesthattheshareishiddenfromviewwhenusersaccessutilitiessuchasMyNetworkPlacesandbrowsenetworkresources.3.YouaretheadministratorofanewmultiprocessorSQLServer2000computer.Youaremigratingdatafromotherdatabasemanagementsystemstothisserver.Youneedtoloaddatafromtwodatafilesintoanewtableontheserver.Thetableisemptyandhasnoindexes.Youwanttocompletethedataloadasquicklyaspossible.Whatshouldyoudo?(Eachcorrectanswerrepresentspartofthesolution.Chooseallthatapply.)A.Applyabulkupdatelocktothetable.B.Useseparateclientconnectionstoloadthefilesintothetablesimultaneously.C.Createaclusteredindexonthetable.D.SpecifytheFullRecoverymodelforthedatabase.E.SpecifytheBulk-LoggedRecoverymodelforthedatabase.請看正確答案：ABEApplyabulkupdatelocktothetable.Useseparateclientconnectionstoloadthefilesintothetablesimultaneously.SpecifytheBulk-LoggedRecoverymodelforthedatabase.解析：解析：Explanation:4.YouwanttoupgradeaWindowsNTServer4.0computernamedServer34toWindows2000Server.Server34isamemberserverinaWindows2000domainnamedmarketing.fabrikam.local.Thedomainrunsinnativemode.YouwanttochangetheroleofServer34fromamemberservertoadomaincontrollerinthesamedomain.Whatshouldyoudo?(ChooseTwo)A.ReinstallWindowsNTServer4.0onServer34inthesameWINNTfolder,andmakeServer34aBB.DC.inthemarketingdomain.D.UseServerManageronServer34andpromoteServer34toaPDCforthemarketingdomain.請看正確答案：BCDinthemarketingdomain.解析：解析：Explanation:ToupgradeaWindowsNT4.0memberservertoaWindows2000DomainControllerwemustfirstupgradetheWindowsNT4.0memberservertoWindows2000ServerandtheninstallActiveDirectoryServicesthroughtheActiveDirectoryInstallationWizard,whichcanbestartedwiththeDCPROMO.EXEcommandorbytheConfigureYourServerutilityinAdministrativetools.5.YouaretheadministratorofaSQLServer2000computer.Theservercontainsyourcompany'sorderprocessingdatabase.Two-hundredoperatorstakeordersbytelephone24hoursaday.Threehundreddataentrypersonnelenterdatafromordersreceivedbymail.Toensurethatorderdatawillnotbelost,yourcompany'sdisasterrecoverypolicyrequiresthatbackupsbewrittentotape.Copiesofthesetapesmustbestoredatanoff-sitecompanylocation.Ordersmustbeenteredintothedatabasebeforetheycanbefilled.Iftheserverfails,youmustbeabletorecovertheorderdataasquicklyaspossible.A.Youneedtocreateabackupstrategythatmeetsthecompanyrequirementsandminimizesserverworkload.Whichtwoactionsshouldyoutake?(Eachcorrectanswerrepresentspartofthesolution.Choosetwo.)B.Perform.acombinationoffulldatabaseandfilegroupbackups.C.Perform.acombinationoffulldatabaseandfilebackups.D.Perform.acombinationoffulldatabase,differential,andtransactionlogbackups.E.Backupthedatatoalocaltapedrive.F.Backupthedatatoanetworkshare,andthenuseenterprisebackupsoftwaretowritethediskbackupstotape.請看正確答案：DFPerform.acombinationoffulldatabase,differential,andtransactionlogbackups.Backupthedatatoanetworkshare,andthenuseenterprisebackupsoftwaretowritethediskbackupstotape.解析：解析：Explanation:6.YouaretheadministratorofseveralSQLServer2000computers.AdataTransformationServices(DTS)packageusesnativeOLEDBproviderstotransferdatabetweentheservers.Connectiondetailsfortheserversarespecifiedin.udlfiles.The.udlfilesarefrequentlyupdatedasconnectiondetailschange.YouwanttodistributetheDTSpackageasafiletodevelopersinyourcompany.YouwanttomakesureconnectiondetailsareavailabletodeveloperswhoreceivetheDTSpackage.A.Whichtwotasksshouldyouperform?(Eachcorrectanswerpresentspartofthesolution.Choosetwo)B.EnabletheAlwaysreadpropertiesfromUDLfileoptionintheConnectionPropertiesdialogbox.C.DisabletheAlwaysreadpropertiesfromUDLfileoptionintheConnectionPropertiesdialogbox.D.Deletethe.udlfilesandstoreconnectiondetailsintheregistrybyusingsystemdatasourcenames.E.Deletethe.udlfiles,andstoreconnectiondetailsintheregistrybyusinguserdatasourcenames.F.Makethe.udlfilesavailableonanetworkshare.請看正確答案：BFEnabletheAlwaysreadpropertiesfromUDLfileoptionintheConnectionPropertiesdialogbox.Makethe.udlfilesavailableonanetworkshare.解析：解析：Explanation:7.YourecentlyupgradedallWindowsNTWorkstation4.0computerstoWindows2000Professional.YouwanttogiveanewemployeenamedMariatheabilitytobackupfiles,shareresources,andinstallprogramsonaclientcomputerthatsheshareswithotherusers.YoudonotwantMariatobeabletoreadotherusers'files.Whatshouldyoudotoaccomplishthesegoals?(Chooseallthatapply)A.AddMaria'suseraccounttotheSystemgroup.B.AddMaria'suseraccounttotheInteractivegroup.C.AddMaria'suseraccounttothePowerUsersgroup.D.AddMaria'suseraccounttotheAdministratorsgroup.E.AddMaria'suseraccounttotheBackupOperatorsgroup.請看正確答案：CEAddMaria'suseraccounttothePowerUsersgroup.AddMaria'suseraccounttotheBackupOperatorsgroup.解析：解析：Explanation:ByaddingMaria'suseraccounttothePowerUsersgroupMariawillinherittheabilitytoshareresourcesandinstallprogramsonthecomputer.TograntMariatheabilitytobackupfilesshemustbeaddedtotheBackupOperatorsgroup,whichhasthepermissionstobackupfiles.AsamemberofthisgroupMariawillbeabletobackupfilesasshewillinheritthoserightsbyvirtueofbeingamemberofthatgroup.Mariawillnothavepermissionstoreadtheusers'filesasneitherthePowerUsersgroupnortheBackupOperatorsgrouphavethepermissionstoreadotherusers'files.8.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:9.YouaretheadministratorofaSQLServer2000computer.TheservercontainsaDataTransformationServices(DTS)packagethatqueriesmultipledatabasesandwritestheresultstoatextfile.YourunthispackagebyusingaMicrosoftWindowsbatchfile.ThebatchfileusesthedtsrunutilitytoexecutetheDTSpackage.Youwanttoensurethatconnectionproperties,suchasloginnamesandpasswords,cannotbereadormod