[单选题]You are the administrator of a Windows 2000 network. Your network includes 75 Windows NT Workstation 4.0 computers. You are adding 50 new PXE-compliant computers to the network. The hardware on each computer is configured identically.You are using a RIS image to deploy Windows 2000 Professional to the 50 computers. You successfully install Windows 2000 Professional on the first 10 computers. However, you cannot install Windows 2000 Professional on remaining 40 computers.

正确答案 ：B

Configure the DHCP scope to add additional IP addresses.

解析：解析：Explanation: RIS requires Active Directory, DNS and DHCP. The clients can either be PXE-compliant or they can use a Remote boot diskette. In this scenario, the DHCP server has run out of IP-addresses. By extending the scope by 40 IP addresses the installation on the remaining computers will be successful.

[多选题]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 a database administrator in the Los Angeles branch office of a specialty foods supplier. A mainframe. database at the headquarters contains all company data. Each branch office contains a SQL Server 2000 computer that imports regional data from the mainframe. database.The server in Los Angeles contains a Data Transformation Services (DTS) package that uses OLE DB to connect to the company's mainframe. database. The DTS package extracts and transforms data about buyers and products for that region. The DTS package then writes the data to the SQL Server database in Los Angeles.

正确答案 ：F

On the server in Sydney, install an OLE DB provider for the mainframe. database.

解析：解析：Explanation: OLE DB is an API that allows COM applications to use data from OLE DB data sources, which includes data stored in different formats. An application uses an OLE DB provider to access an OLE DB data source. An OLE DB provider is a COM component that accepts calls to the OLE DB API and performs the necessary processing required by request against the data source. In this scenario the OLE DB source is the company's mainframe. database, which contains all company data. As each branch office contains a SQL Server 2000 computer that imports regional data from the mainframe. database, all existing and future branch office SQL Server 2000 servers will require an OLE DB provider to access the company's mainframe. database.

[单选题]You are the administrator of two SQL Server 2000 computers. One of these servers contains a 4-GB database named marketing. You want to remove the marketing database from one server and add it to the other as quickly as possible.What should you do?

正确答案 ：A

Detach the database from the original server by using the sp_detach_db stored procedure. Copy the database and the transaction log files to the new server, and attach them by using the sp_attach_db stored procedure.

解析：解析：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.

[单选题]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 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 new multiprocessor SQL Server 2000 computer. You are migrating data from other database management systems to this server. You need to load data from two data files into a new table on the server. The table is empty and has no indexes.You want to complete the data load as quickly as possible. What should you do? (Each correct answer represents part of the solution. Choose all that apply.)

正确答案 ：ABE

Apply a bulk update lock to the table.

Use separate client connections to load the files into the table simultaneously.

Specify the Bulk-Logged Recovery model for the database.

解析：解析：Explanation:

[单选题]You have 17GB of private files on drive D on your Windows 2000 Professional computer. You have shared the files as private_files. You do not want other users to see this share name in the browse list.You want all other share names to continue to appear in the browser list.What should you do?

正确答案 ：C

Change the share name to private_files$.

解析：解析：Explanation: By appending a dollar sign to the end of the share name, the share is hidden and the folder will not be shown in any browse list. Only users who know the folder name can gain access to it if they also possess the proper permissions to it.

[单选题]You copy the contents of the Windows 2000 Professional CD to a shared network folder named \\Server1\Win2000p. You use the shared folder to perform. over-the-network installations of Windows 2000 Professional on new computers purchased by your company.You receive a Windows 2000 Service Pack CD. You apply the Service Pack to Server1 and to the \\Server1\Win2000p folder.

正确答案 ：D

Select the Uninstall option.

解析：解析：Explanation: The service pack that has been applied, or slipstreamed, to the installation files and cannot be unapplied. You thus have to replace the installation files in the network share with the original Windows 2000 installation files.

[单选题]You are the administrator of a new Microsoft Windows 2000 server computer named HQSQL5. HQSQL5 is a member server in your company's Windows NT 4.0 domain, which is named HQMAIN.After installing SQL Server 2000 on HQSQL5, you configure the MSSQLServer service account to use the HQMAIN\sqladmin user account, which is a member of the local administrators group on HQSQL5.

正确答案 ：E

Grant Log on as a service rights to the HQMAIN\sqladmin user account.

解析：解析：Explanation: On Windows NT and Windows 2000 operating systems, SQL Server 2000 and SQL Server Agent are started and run as Windows services. Windows services require ‘Log on as a service’ rights, which allow a security principal to log on as a service, as a way of establishing a security context. The Local System account on the Windows computer always retains the right to log on as a service. Any service that runs under a separate account must be granted this right.

查看原题