[单选题]You are the administrator of a Windows NT 4.0 Terminal Server Edition computer. The server has one hard disk, which is divided into two partitions The first partition contains the Windows NT 4.0 system files and is formatted as FAT. The second partition contains application data and user data. This second partition is formatted as NTFS. The server currently has Service Pack 3 installed.You need to upgrade the server to Windows 2000 Server. You want to ensure that no application data or user data is lost during the upgrade. You also want to perform. the minimum number of steps necessary to complete the upgrade.
正确答案 :C
Install service pack4 or later on the server.
解析:解析:Explanation: To ensure that no application data or user data is lost during the upgrade the following two steps will be taken:
[多选题]The network consists of a single domain named Ezonexam.com that includes 20 Windows NT workstation 4.0 client computers. All other client computers are Windows 2000 Professional computers. You install Terminal Services on one of the Windows Server computers and Terminal Services Client on the 20 Windows NT Workstation 4.0 client computers. You create a system policy on the server that is configured as the terminal server. This system policy denies access to Network Neighborhood. You find that the users of the terminal server can still browse the network when they open My Network Places from Windows 2000 Professional computer or when they open Network Neighborhood from Windows NT Workstation 4.0 computers.You want to prevent all users from browsing the network.
正确答案 :BD
Create a Windows Group Policy that denies user access to My Network Places.
Create a Windows NT 4.0 default user policy on the Windows 2000 Server computer that is configured as the PDC emulator.
解析:解析:Explanation: The primary domain controller (PDC) is the server that maintains the master copy of the domain's user-accounts database and that validates logon requests. Prior to Windows 2000 every Windows NT network domain was required to have one, and only one, PDC. If you want to deny users of the terminal server browsing ability of the Network Neighborhood, you should create a group policy that denies access to My Network Places. (Microsoft is colloquially stuck with Network Neighborhood for My Network Places.)
[单选题]You are the administrator of a SQL Server 2000 computer named SQL1. You want to perform. ad hoc distribution queries against a database that is stored on a SQL Server 2000 computer named SQL2. SQL2 contains several databases, and each of these databases uses a different collation.You want to ensure that comparisons in distributed queries are evaluated correctly. You also want to minimize administrative overhead.
正确答案 :D
Add SQL2 as a linked server. Select the Use Remote Collation check box, and do not specify a collation name.
解析:解析: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.
[单选题]You want to upgrade a Windows NT Server 4.0 computer to Windows 2000 Server. The system partition uses the FAT file system.You start the Setup program by starting the computer from the Windows 2000 Server CD-ROM.
正确答案 :E
Restart the computer, and then run Winnt32.exe from the Windows NT Server 4.0 environment.
解析:解析:Explanation:WhenupgradingearlierversionsofWindowstoWindows2000wemustusewinnt32.exeandmustlaunchitfromwithintheWindowsenvironment.Incorrectanswers:A:Windows2000canbeinstalledorupgradedonadiskorpartitionthatisformattedwiththeFATfilesystem.ThereisthusnoneedtoconvertthefilesystemtoNTFS.B:TheAdvancedConfigurationandPowerInterfaceisusedforpowermanagementanddoesnotaffecttheinstallationorupgradeprocess.ItwouldthusnotbenecessarytodisableACPI.D:ThesetupfloppydisksuseWinnt.exetoinstallWindows2000.WehowevercanonlyusethesetupfloppydiskstoinstallacleancopyofWindows2000onthecomputer.WecannotupgradetheoperatingsystemtoWindows2000usingthesetupfloppydisks.Wemustusewinnt32.exetoupgradeearlierversionsofWindowstoWindows2000.
[单选题]You are the administrator of a SQL Server 2000 computer. The server contains confidential information about contracts on which your company has placed bids.Company policy requires that bid information be removed permanently from the database one year after the bid closes. You need to comply with this policy and minimize server overhead.
正确答案 :D
Create a stored procedure to delete any bids that have a closing data order than one year. Use SQL server agent to schedule the stored procedure to run every night.
解析:解析:Explanation:Thisscenariorequiresustoremoveoldinformationonaregularbasis.Firstwecreateastoredprocedurewhichremovesallrowswherethebidinformationdateisolderthanthecurrentdateminusoneyear.Thenweschedulethisproceduretoruneveryday.Wewouldthenbesuretoneverhaveanyrowsolderthanayearinthetable.Note:Storedproceduresalsoimproveperformanceasthestoredprocedureiscachedafteritisrun.ThisresultsinareductionofphysicalI/O.WecanfurtherreduceServeroverheadbyschedulingthestoredproceduretorunduringoff-peakhours.IncorrectAnswers:A:ADataTransformationServices(DTS)packageprovidesasetoftoolsthatallowsustoextract,transform,andconsolidatedatastoredinavarietyofformatsandindifferentlocationsintosingleormultipledestinationssupportedbyDTSconnectivity.Thissolutionisinappropriate,asthedataexistsontheserverandnotinnumerouslocationsandwouldthusbecorrectlyformattedforuseonaninstanceSQLServer2000.B:TriggersareaspecialtypeofstoredprocedurethatexecutesautomaticallywhenanUPDATE,INSERT,orDELETEstatementisrunagainstatableorview.Inthisscenariohowever,thedatestampofthedatainthedatabasemustbecheckedandthedatadeletedoneyearafterthebidhasclosed.Thiscannotbeaccomplishedthroughtheuseofconstraintsortriggers.D:Creatingaviewthatexcludesthebidsthathaveaclosingdateolderthanoneyeardoesnotaddressthecompanypolicythatrequiresthatbidinformationberemovedpermanentlyfromthedatabaseoneyearafterthebidcloses.Thisdatawillstillexistinthebasetables.
[单选题]Your Windows 2000 Server computer has a 10-GB hard disk with two partitions: Drive C and drive D. Windows 2000 Server is installed on Drive D. Both partitions are formatted as NTFS. Your office experiences a power failure that causes your Windows 2000 Server computer to restart.When the computer is restarting, you receive the following error message "NTLDR is missing. Press any key to restart".
正确答案 :B
Start the computer by using Windows 2000 Server computer CD-ROM and choose to repair the installation. Select the Recovery Console and copy the NTLDR file on the CD-ROM to the root of the system partition.
解析:解析:Explanation:Theproblemposedinthisscenariocouldarisefromanumberofcauses.ItcouldbethattheNTLDRismissing,orthebootsectoriscorrupt,orthediskisphysicallydamaged.IfweassumethattheproblemcausedbyamissingNTLDR,wecoulduseeithertheEmergencyRepairDisk(ERD)ortheRecoveryConsoletocorrectheproblem.UsingeithertheEmergencyRepairDiskortheRecoveryConsolewewouldattempttocopytheNTLDRfilefromtheWindows2000installationCD-ROMtotherootofthesystempartition,whichcouldsolvethebootproblem.Incorrectanswers:B:Debuggingmodeisaspecialsafemodeoptionthatusedbydeveloperstodebugprograms.ItcannotbeusedrestoretheNTLDR.C:Windows2000doesnotsupportabootablefloppydisk,althoughthefourWindows2000setupdiskscouldbeusedtostartthecomputerinWindows2000.TheRecoveryConsoleortheERDprocessmustbeusedtorestoretheNTLDR.D:TheFileSignatureVerificationutilityisusetotesttheintegrityofdevicedrivers.ItcannotbeusedrestoretheNTLDR.
[单选题]From your Windows 2000 Professional computer, you need to map drive G to the default administrative share on drive C of a server named AppSrv.What can you do to map the drive?
正确答案 :B
Run thenet use G: \\AppSrv\C$command.
解析:解析:Explanation:Therootofeachvolumeonaharddiskisautomaticallyshared,andthesharenameisthedriveletterappendedwithadollarsign($).Theappendeddollarsigncausesthesharetobehidden.Onemethodofmappingasharetoalogicaldriveistoopenthecommandpromptandtypethecommand:NETUSEdevicename:\\computername\sharename.Inthisscenario,thecommandtranslatestothecommand:netuseG:\\AppSrv\C$IncorrectAnswers:A:Thenetsharecommandisusedtocreatesharesnottoconnecttoexistingsharesonothercomputersinthenetwork.C:ItisnotpossibletobrowsetotheadministrativeshareC$onAppSrvsincethisisahiddenshare.D:ItisnotpossibletobrowsetotheadministrativeshareC$onAppSrvsincethisisahiddenshare.
[单选题]You are the network administrator for Ezonexam. You are planning to upgrade 35 Windows NT Server 4.0 computers to Windows 2000 Server. You want to accomplish the upgrades by using a distribution server. The Windows NT Server 4.0 computers support a tight production schedule that requires them to be online from 8:00
正确答案 :D
Perform. an unattended installation by running the winnt32 command and specify the use of a .txt file and a uniqueness database file.
解析:解析:Explanation: Performing an unattended installation from a distribution server will work since the upgrade must be done in non-business hours.
[单选题]You are the administrator of a SQL Server 2000 computer. You create several jobs on the server and schedule them to run during the evening.You configure an operator on the server and configure the jobs to send an e-mail to this operator if a job fails for any reason.
正确答案 :C
Configure SQLAgentMail to use a valid MAPI profile
解析:解析: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.
[单选题]Your network includes Windows 98 computers and Windows 2000 Server computers. You are adding a new computer to the network, and you plan to install Windows 2000 Server on the new computer. The computer has one 20-GB hard disk with no partitions defined.The Windows 2000 Server CD-ROM is unavailable. You want install Windows 2000 Server from source files that are located on a server on the network. You also want the entire hard disk of the new computer to be used for the system partition.
正确答案 :E
Start the new computer by using a Windows 98 network boot disk. Create and format a single FAT32 partition. Connect to the network server. Run Winnt.exe.
解析:解析:Explanation: To install Windows 2000 Server on computers from source files that are located on a centralized network share we would have to connect to the network share from the the computers. If the computers do not have PXE-compliant network cards we would have to make a network boot disk that the computers can use connect to the network share. We would start the installation process by using winnt with /s /u /udf switches. We must use winnt and not winnt32 as the boot disks operate in DOS mode, which works with 16-bit applications. We would thus not be able to use 32-bit applications like winnt32.
查看原题