[单选题]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 are the administrator of your company's network. An employee named Mark is leaving the company. A new employee named Eric has been hired to replace him.Mark has a local user account on a Windows 2000 Professional computer. Mark has rights to multiple files and folders on the computer.
正确答案 ：C
Rename Mark's user account to Eric and change the account password.
解析：解析：Explanation: A user account and the permission and rights attached to them can easily be transferred to another user by renaming the account and changing the password. By renaming Mark's user account and by changing the password, Eric will have the same rights and permissions as Mark had, and Mark will not be able to use his old account. This provides the solution with least amount of administrative effort.
[单选题]You are the administrator of a network that consists of Windows 2000 Server Computers and Windows 2000 Professional computers.You want to configure the deployment of the most recent Windows 2000 Service pack so that users of the Windows 2000 Professional Computers receive the service pack automatically when they log on to the domain.
正确答案 ：C
Create a Microsoft Windows installer package for the service pack. Configure the package in a group policy.
解析：解析：Explanation:TodeploythemostrecentWindows2000ServicepacksothatusersoftheWindows2000Professionalcomputersreceivetheservicepackautomaticallywhentheylogontothedomain,wemustcreateanduseaWindowsInstallerpackageandapplyitthroughaGroupPolicy.Incorrectanswers:A:Windowsinstallerpackagesshouldbedeployedbygrouppolicies.RIS,RemoteInstallationServices,isusedtoremotelyinstallWindows2000Professional.C:Ifwedeploytheinstallerpackagewithalocalpolicywewouldhavetomanuallyconfigurethepolicyonallclients.ThiscouldrequireconsiderableadministrativeeffortD:DFSisusedtoorganizenetworkfolders,nottodeployupdatesofapplications.
[多选题]You are the network administrator for Ezonexam. The network consists of a single Active Directory domain Ezonexam.com. All network servers run Windows Server 2000.Your network includes a shared folder named EzonexamDocs. This folder must not be visible in a browse list.
正确答案 ：EF
Change the share name to EzonexamDocs .
Change the share name to EzonexamDocs $.
解析：解析：Explanation: Appending a dollar sign ($) to a share name hides the share. A share that is followed by a dollar sign ($) indicates that the share is hidden from view when users access utilities such as My Network Places and browse network resources.
[单选题]You are upgrading computer1 and computer2 from Windows NT Workstation 4.0 to Windows 2000 Professional. You successfully upgrade computer1. During the upgrade of computer2, a series of power outages interrupts the upgrade.You discover that the upgrade of computer2 is incomplete. Furthermore, you find that computer2 can no longer run Windows NT workstation 4.0. Computer2 does not support booting from the Windows 2000 Professional CD-ROM. You decide to use computer1 to help recover the failed upgrade.
正确答案 ：D
On the computer1, run Makebt32.exe from the Bootdisk folder on the Windows 2000 Professional CD-ROM. On computer2, restart the upgrade by using the newly created floppy disks.
解析：解析：Explanation: You can create the four setup boot disks by using either makeboot.exe or makebt32.exe. Both are located in the \Bootdisk directory on the Windows 2000 installation CD. These disks can be used to restart the installation process on computer2.
[单选题]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.
[单选题]You are the administrator of a Windows 2000 Active Directory network. The network consists of a single domain. The domain includes 20 Windows NT Workstation 4.0 client computers. All other client computers are Windows 2000 Professional computers.You create a Windows NT 4.0 default user policy on the Windows 2000 Server computer that is configured as the PDC emulator. This default user policy denies access to Network Neighborhood. You then install Terminal Services on one of the servers and Terminal Services Client on the 20 Windows NT Workstation client computers.
正确答案 ：E
Create a Windows 2000 Group Policy that denies user access to My Network Places.
解析：解析：Explanation: Windows NT 4.0 system polices affect computers running Windows NT 4.0. The Windows NT computers in this scenario are being used as Terminals for the Windows 2000 Server computer that is running Terminal Services. In effect the Windows NT clients are running locally on the Windows 2000 Server. The restriction must be applied on the Windows 2000 Server. This can be done by using a group policy.
[单选题]You are the administrator of a Windows NT Server 4.0 computer named Ezonexam1. Ezonexam1 is a backup domain controller (BDC), and a member of Ezonexam.com's Windows 2000 Active Directory domain. Ezonexam1 contains five hard disks. Disk 0 and 1 are configured as a Windows NT 4.0 mirror set.The mirror set contains the operating system files and 500 MB of free disk space. Disk 2, 3 and 4 are configured as a Windows NT 4.0 stripe set with parity and contain employee data files. The Windows NT 4.0 stripe set with parity has a maximum capacity of 140 GB and contains 15 GB of free disk space.
正确答案 ：F
Upgrade Ezonexam1 to Windows 2000 Server. During the upgrade, select the option to make Ezonexam1 a domain controller. After the upgrade is complete, demote Ezonexam1.
解析：解析：Explanation: We upgrade Ezonexam1. We have no choice that the upgraded Windows 2000 Server will be a domain controller. We are then able to use the dcpromo.exe utility to remove the Active Directory and demote the Domain controller to a member server.
[多选题]You are the administrator of a SQL Server 2000 computer. The server contains your company's order processing database. Two-hundred operators take orders by telephone 24 hours a day. Threehundred data entry personnel enter data from orders received by mail.To ensure that order data will not be lost, your company's disaster recovery policy requires that backups be written to tape. Copies of these tapes must be stored at an off-site company location. Orders must be entered into the database before they can be filled. If the server fails, you must be able to recover the order data as quickly as possible.
正确答案 ：DF
Perform. a combination of full database, differential, and transaction log backups.
Back up the data to a network share, and then use enterprise backup software to write the disk backups to tape.
解析：解析：Explanation:
[单选题]You are the administrator of a Windows 2000 Server network. On each server, you format a separate system partition and a separate boot partition as NTFS.Several months later, you shut down one of the servers for the maintenance. When you try to restart the server, you receive the following error message "NTLDR is missing. Press any key to restart".
正确答案 ：B
Start the computer by using the Windows 2000 Server 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 volume.
解析：解析：Explanation: If the boot sector cannot find NTLDR, Windows 2000 cannot start. This can be caused by moving, renaming, or deleting Ntldr, corruption of Ntldr, or corruption of the boot sector. Under these circumstances, the computer might not respond to input or might display an error message. The Recovery Console can be used to restore the ntldr.exe file. This process would not create any other side effects.
查看原题 点击获取本科目所有试题
