2023年微软认证笔试历年高频考点试卷带答案

长风破浪会有时，直挂云帆济沧海。住在富人区的她2023年微软认证笔试历年高频考点试卷带答案第1卷一.单选题(共10题)1.YouplantoinstallWindows2000Serveron10newcomputers.TheseserverswillprovidefileandprintservicesinbranchofficesofE.ThecompanywantseachbranchofficetopurchaseitsowncopyofWindows2000Server,andtheinstallationineachbranchofficeshouldusetheserialnumberassociatedwiththebranchoffice'sowncopy.Youwanttoinstall,configure,andtestWindows2000Serveronthesecomputersatthemainofficebeforeshippingthecomputerstothebranchoffices.Youwantusersinthebranchofficetoenterthecomputernamesandserialnumberswhentheyreceivethecomputers.A.Whatshouldyoudo?B.InstallWindows2000Serveronthecomputersbyusinganunattend.txtfile,andthenusetheregistryeditortoremovethecomputernameandlicensedetails.C.StarttheinstallationprocessfromanMS-DOSbootdisk.InstallWindows2000ServeronthecomputersfromanexistingserverbyrunningtheWinntcommandwiththePreInstswitch.D.InstallWindows2000Serveronthecomputers,andthenuseSetupManagertocreateasysprep.inffileforsysprep.exe.Placethesysprep.inffileonthecomputersandrunthesysprep-nosidgencommand.E.Createanunattend.txtfilebyusingSetupManager.Includethefollowinglineintheunattend.txtfile.emPrenistall=YES.Usethisfiletoperform.theinstallation.请看正确答案：DInstallWindows2000Serveronthecomputers,andthenuseSetupManagertocreateasysprep.inffileforsysprep.exe.Placethesysprep.inffileonthecomputersandrunthesysprep-nosidgencommand.解析：解析：Explanation:ToinstallWindows2000Serverondifferentcomputersusingdifferentserialnumbers,wewouldhavetoinstallWindows2000Serverononecomputerandthenusesyspreptocreateasysprep.inffile.Wecantheusethesysprep-nosidgencommandtopreventthecomputersSIDfrombeingreplicated:theuserswillentercomputernamesandserialnumberswhentheyinstalltheclone.2.YouareadatabaseadministratorintheLosAngelesbranchofficeofaspecialtyfoodssupplier.Amainframe.databaseattheheadquarterscontainsallcompanydata.EachbranchofficecontainsaSQLServer2000computerthatimportsregionaldatafromthemainframe.database.TheserverinLosAngelescontainsaDataTransformationServices(DTS)packagethatusesOLEDBtoconnecttothecompany'smainframe.database.TheDTSpackageextractsandtransformsdataaboutbuyersandproductsforthatregion.TheDTSpackagethenwritesthedatatotheSQLServerdatabaseinLosAngeles.A.YouneedtoconfigureaSQLServercomputerforthenewbranchofficeinSydney.YouwanttocopytheLosAngelespackageandmodifyitsothatitwritesdatatotheSQLServerdatabaseinSydney.B.YouusetheDTSDesignertomodifytheDTSpackagesothatitimportsregionaldatafromthemainframe.databasetotheserverinSydney.ThemodifiedDTSpackagerunssuccessfullyontheserverinLosAngeles.YousavethisDTSpackagetotheserverinSydney,buttheserverinSydneycannotconnecttothemainframe.database.C.YouwanttoenabletheserverinSydneytoconnecttothemainframe.database.Whatshouldyoudo?D.ChangetheconnectionpropertiesintheDTSpackagesothatthepackageusesnewlogincredentialstoconnecttothemainframe.database.E.ModifytheworkflowintheDTSpackagesothattheserverinSydneyisincluded.F.OntheserverinSydney,installanOLEDBproviderforthemainframe.database.G.OntheserverinSydney,deleteandthenre-createtheDTSpackage.请看正确答案：FOntheserverinSydney,installanOLEDBproviderforthemainframe.database.解析：解析：Explanation:OLEDBisanAPIthatallowsCOMapplicationstousedatafromOLEDBdatasources,whichincludesdatastoredindifferentformats.AnapplicationusesanOLEDBprovidertoaccessanOLEDBdatasource.AnOLEDBproviderisaCOMcomponentthatacceptscallstotheOLEDBAPIandperformsthenecessaryprocessingrequiredbyrequestagainstthedatasource.InthisscenariotheOLEDBsourceisthecompany'smainframe.database,whichcontainsallcompanydata.AseachbranchofficecontainsaSQLServer2000computerthatimportsregionaldatafromthemainframe.database,allexistingandfuturebranchofficeSQLServer2000serverswillrequireanOLEDBprovidertoaccessthecompany'smainframe.database.3.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.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.YouarethenetworkadministratorforE.Youareplanningtoinstall10newWindows2000Servercomputers.EzonexamhasatightproductionschedulethatrequiresnochangesbemadetotheActiveDirectoryexceptduringscheduledoutages.Youscheduletheinstallationsduringanupcomingnetworkoutagewhichwilloccurbetweenmidnightand8:00A.M.B.Youwanttocompletetheinstallationsbeforeproductionbeginsinthemorning.C.Whatshouldyoudo?D.Perform.theinstallationsbyusingfourfloppydiskscreatewiththeMakebt32.exeutility.E.Perform.theinstallationsbyusingfourfloppydiskscreatewiththeMakeboot.exeutility.F.Perform.theinstallationsbyusingtheWindows2000Installationcompactdisc.G.Perform.theinstallationsbyusingtheWindows2000InstallationcompactdiscandafloppydiskcontainingaWinnt.siffile.请看正确答案：GPerform.theinstallationsbyusingtheWindows2000InstallationcompactdiscandafloppydiskcontainingaWinnt.siffile.解析：解析：Explanation:WemustuseSetupManagertocreateawinnt.sif.Wemustthencopythisfiletoafloppy.ThenstarttheinstallationprocessfromtheCD-ROMandinsertthefloppydisk.Theinstallationprocesswillbeafullyautomatedunattendedinstallation.6.YouconfigureaGroupPolicyObjectfortheMarketingorganizationalunit(OU)topreventusersfromaccessingMyNetworkPlacesandfromrunningSysteminControlPanel.YouwanttheManagersdomainlocalgrouptobeabletoaccessMyNetworkPlaces,butyoustillwanttopreventthemfromrunningSysteminControlPanel.Whatshouldyoudo?A.AddthemanagersgrouptotheaccesscontrollistoftheGPO.Disablethepermissionofthemanagersgrouptoreadandapplythegrouppolicy.B.AddthemanagersgrouptotheaccesscontrollistoftheGPO.Denythepermissionofthemanagersgrouptoreadandapplythegrouppolicy.C.CreateasecondGPOintheOU.Addthemanagersgrouptotheaccesscontrollist.Allowthemanagersgrouptoapplythegrouppolicy.Denytheauthenticatedusersgrouppermissiontoreadandapplygrouppolicy.ConfigurethenewGPOtodenytheabilitytorunSysteminControlPanel.GivetheoriginalGPOahigherprioritythanthenewGPO.D.CreateasecondGPOintheOU.Addthemanagersgrouptotheaccesscontrollist.Allowthemanagersgrouptoreadandapplythegrouppolicy.Disablethepermissionoftheauthenticatedusergrouptoreadandapplythegrouppolicy.ConfigurethenewGPOtoallowaccesstoMyNetworkPlaces.GivethenewGPOahigherprioritythantheoriginalGPO.请看正确答案：DCreateasecondGPOintheOU.Addthemanagersgrouptotheaccesscontrollist.Allowthemanagersgrouptoreadandapplythegrouppolicy.Disablethepermissionoftheauthenticatedusergrouptoreadandapplythegrouppolicy.ConfigurethenewGPOtoallowaccesstoMyNetworkPlaces.GivethenewGPOahigherprioritythantheoriginalGPO.解析：解析：Explanation:InthisscenarioweneedtocreateasecondGPOandapplyitonlytotheManagers.WemustallowaccesstoMyNetworkPlacesinthenewGPO.ThenwegivetheGPOhigherprioritythantheoriginalone.Incorrectanswers:A:WestillrequiretheoriginalGPOtoapplytothemanagers,aswewanttopreventthemfromrunningSysteminControlPanel.ThereforeweshouldnotdisablethepermissionofthemanagersgrouptoreadandapplytheGroupPolicy,asthiswillresultintheGPOnotbeingappliedtotheManagers.B:WestillrequiretheoriginalGPOtoapplytothemanagers,aswewanttopreventthemfromrunningSysteminControlPanel.ThereforeweshouldnotdenythepermissionofthemanagersgrouptoreadandapplytheGroupPolicy,asthiswillresultintheGPOnotbeingappliedtotheManagers.C:WeneedtoallowtheManagersaccesstoMyNetworkPlaces.ThatmustbeconfiguredinthesecondGPO.7.Youaretheadministratorofyourcompany'snetwork.AusernamedPaulintheservicedepartmenthasaWindows2000Professionalcomputer.Paulneedstoaccessthefilesthatareinasharedfolderonhiscomputer.AlocalgroupnamedSaleshaspermissionstoaccessthedata.PaulisamemberoftheSaleslocalgroupbuthecannotaccessthefileheneeds.Whatshouldyoudo?A.GrantPaulNTFSpermissionsothathecanaccessanyparentfoldertofilesinthesharedfolder.B.SharetheSalesfolderandgrantPaulsharedfolderpermissiontoaccessthesharedSalesfolder.C.RemovePaulfromanyothergroupthathasbeenexplicitlydeniedaccesstotheSalesfolder.D.DeletetheSaleslocalgroupandrecreateit.AddindividualuseraccountsfromtheSalesdepartmentbackintoSaleslocalgroup.请看正确答案：CRemovePaulfromanyothergroupthathasbeenexplicitlydeniedaccesstotheSalesfolder.解析：解析：Explanation:TheSalesgroup,whichPaulisamemberof,haspermissiontoaccessthefiles.However,Paulstillcannotaccessthefiles.ItwouldseemthatPaulhasapermissionsconflict.Ausercanbegrantedfilepermissionsinanumberofcontexts:asauserorasamemberofausergroup.Whenauserhasdifferentfilepermissionsinmultiplecontexts,themostrestrictivepermissionisapplied.Furthermore,thedenypermissionoverridesallotherpermissions.AsPauldoesnothaveaccesstothefileyoumustthereforeassumePaulhasexplicitlybeendeniedaccesstothefileinsomecontext,asmemberofoneormoregroupsthathavebeendeniedaccesstothefile.YouwouldthushavetoremovePaulfromsuchagroupsothattherestrictionisnotappliedtoPaul.8.YouaretheadministratorofaSQLServer2000computer.Youcreateseveraljobsontheserverandschedulethemtorunduringtheevening.Youconfigureanoperatorontheserverandconfigurethejobstosendane-mailtothisoperatorifajobfailsforanyreason.A.Whiletestingthejobs,youdiscoverthate-mailmessagesarenotbeingsenttotheoperatorwhenajobfails.YouuseSQLServerEnterpriseManagertoconfirmthatSQLMailisstarted.B.Youneedtoensurethate-mailmessagesaresenttotheoperatorwheneverajobfails.Whatshouldyoudo?C.ConfigureSQLAgentMailtouseavalidMAPIprofileD.ConfigureSQLMailtouseamailboxthatdelegatespermissionstotheoperatorE.Usethenetsendnotificationmethodtosendtheoperatore-mailmessagesF.Createajobthatexecutesthexp_startmailstoredprocedureConfigurethejobtorunwheneverSQLServer2000starts请看正确答案：CConfigureSQLAgentMailtouseavalidMAPIprofile解析：解析：Explanation:SQLAgentMailmustbeusedwhenmailstoredproceduresareusedtosendnotificationstooperatorsbye-mailorpager.InordertouseSQLAgentMail,amailprofilemustbeconfiguredforSQLServerAgenttousetoconnecttothemailserverandthemailservermustbeextendedMAPI-compliant.IncorrectAnswers:B:SQLMailprovidesawaytoreceivee-mailmessagesgeneratedbySQLServer2000.Messagescanbetriggeredtoprovideinformationaboutthestatusofajoborawarningcausedbyanalert.SQLMailcanincludearesultsetinareplytoe-mailmessagesthatcontainqueriesandallowsSQLServertosendandreceivee-mailbyestablishingaclientconnectionwithamailserver.However,SQLMailmusthaveamailprofilecreatedinthesameuserdomainaccountorcontextthatisusedtostartaninstanceofSQLServer2000asitlooksforthedefinedmailprofileinthedomainaccountthattriggeredthee-malmessage.C:Netsendisusedtosendsmessagestootherusers,computers,ormessagingnamesacrossanetwork.TheMessengerservicemustberunningtoreceivemessages.Itisnotusedfore-mailorpagingpurposes.D:Thexp_startmailstoredprocedureisusedtostartaSQLMailclientsession.Ifthereisanexistingmailsession,xp_startmaildoesnotstartanewone.IfmailisbeingusedonthesamecomputeronwhichSQLServerisalsorunning,themailclientmustbestartedeitherbeforexp_startmailisexecuted,orbeforeSQLServerisstartedifSQLMailisconfiguredtoautomaticallystartwhenSQLServerstarts.9.YourWindows2000Professionalcomputercontainsasingleharddiskconfiguredasasinglepartition.YouwanttomoveafoldernamedSalesunderafoldernamedCorponyourcomputer.A.YouwantthefilesintheSalesfoldertoremaincompressedaftermovingthefolder.YouwantthefilesintheCorpfoldertoremainuncompressed.Youwanttoensurethatthefilesarerecoverableincaseofanydiskproblems.Youalsowanttomovethefileswiththeleastamountofadministrativeeffort.B.Whatshouldyoudo?C.CopytheSalesfoldertotheCorpfolder.Donothingfurther.D.BackuptheSalesfolder.MovetheSalesfoldertotheCorpfolder.E.CompresstheCorpfolder.ThencopytheSalesfoldertotheCorpfolder.F.MovetheSalesfoldertoasecondcomputer.ThenmovetheSalesfoldertotheCorpfolder.请看正确答案：DBackuptheSalesfolder.MovetheSalesfoldertotheCorpfolder.解析：解析：Explanation:ThecontentsoftheSalesfoldershouldbebackedupsothatfileswouldberecoverableincaseofdiskproblems.YoucouldmovetheSalesfoldertotheCORPfolder,asthefileswillremaincompressedsincethefolderismovedwithinasinglepartition.Thegeneralrulesoncopyingandmovingcompressedfilesandfolderare:filesandfolderscopiedwithinaNTFSvolumeandbetweenNTFSvolumesinheritthecompressionstateofthetargetfolder;filesandfoldersmovedbetweenNTFSvolumesinheritthecompressionstateofthetargetfolder;andfilesandfoldersmovedwithinanNTFSvolumeretaintheoriginalcompressionstateofthefileorfolder.10.YourWindows2000Servercomputerhasa10-GBharddiskwithtwopartitions:DriveCanddriveD.Windows2000ServerisinstalledonDriveD.BothpartitionsareformattedasNTFS.YourofficeexperiencesapowerfailurethatcausesyourWindows2000Servercomputertorestart.Whenthecomputerisrestarting,youreceivethefollowingerrormessage"NTLDRismissing.Pressanykeytorestart".A.Whatshouldyoudo?B.StartthecomputerbyusingWindows2000ServercomputerCD-ROMandchoosetorepairtheinstallation.SelecttheRecoveryConsoleandcopytheNTLDRfileontheCD-ROMtotherootofthesystempartition.C.Startthecomputerindebuggingmode.CopytheNTLDRfileontheCD-ROMtotherootofthesystempartition.D.StartthecomputerbyusingtheWindows2000bootablefloppydisk.Fromacommandprompt,runthesfc/scanbootcommand.E.StartthecomputerbyusingaWindows2000bootablefloppydisk.RuntheFileSignatureVerificationutility.请看正确答案：BStartthecomputerbyusingWindows2000ServercomputerCD-ROMandchoosetorepairtheinstallation.SelecttheRecoveryConsoleandcopytheNTLDRfileontheCD-ROMtotherootofthesystempartition.解析：解析：Explanation:Theproblemposedinthisscenariocouldarisefromanumberofcauses.ItcouldbethattheNTLDRismissing,orthebootsectoriscorrupt,orthediskisphysicallydamaged.IfweassumethattheproblemcausedbyamissingNTLDR,wecoulduseeithertheEmergencyRepairDisk(ERD)ortheRecoveryConsoletocorrectheproblem.UsingeithertheEmergencyRepairDiskortheRecoveryConsolewewouldattempttocopytheNTLDRfilefromtheWindows2000installationCD-ROMtotherootofthesystempartition,whichcouldsolvethebootproblem.Incorrectanswers:B:Debuggingmodeisaspecialsafemodeoptionthatusedbydeveloperstodebugprograms.ItcannotbeusedrestoretheNTLDR.C:Windows2000doesnotsupportabootablefloppydisk,althoughthefourWindows2000setupdiskscouldbeusedtostartthecomputerinWindows2000.TheRecoveryConsoleortheERDprocessmustbeusedtorestoretheNTLDR.D:TheFileSignatureVerificationutilityisusetotesttheintegrityofdevicedrivers.ItcannotbeusedrestoretheNTLDR.二.多选题(共10题)1.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:2.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,E3.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.4.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:5.YouwanttoupgradeaWindowsNTServer4.0computernamedServer34toWindows2000Server.Server34isamemberserverinaWindows2000domainnamedmarketing.fabrikam.local.Thedomainrunsinnativemode.YouwanttochangetheroleofServer34fromamemberservertoadomaincontrollerinthesamedomain.Whatshouldyoudo?(ChooseTwo)A.ReinstallWindowsNTServer4.0onServer34inthesameWINNTfolder,andmakeServer34aBB.DC.inthemarketingdomain.D.UseServerManageronServer34andpromoteServer34toaPDCforthemarketingdomain.请看正确答案：BCDinthemarketingdomain.解析：解析：Explanation:ToupgradeaWindowsNT4.0memberservertoaWindows2000DomainControllerwemustfirstupgradetheWindowsNT4.0memberservertoWindows2000ServerandtheninstallActiveDirectoryServicesthroughtheActiveDirectoryInstallationWizard,whichcanbestartedwiththeDCPROMO.EXEcommandorbytheConfigureYourServerutilityinAdministrativetools.6.YouarethenetworkadministratorforE.Yournetworkhas210Windows2000ProfessionalcomputersandelevenWindows2000Servercomputers.Usersonthenetworksavetheirworkfilesinhomefoldersonanetworkserver.TheNTFSpartitionthatcontainsthehomefoldershasEncryptingFileSystem(EFS)enabled.AusernamedSandraleavesE.Youdecryptthefilesforhermanager.Whenthemanagerattemptstoopenanyofthefiles,hereceivesthefollowingerrormessage:"Accessisdenied."Youwantthemanagertobeabletoaccessthefiles.A.Whatshoulddo?(Eachcorrectanswerpresentsacompletesol