[单选题]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. You create a Data Transformation Services (DTS) package. The package is stored as a local package on the server. The package exports data from an online transaction processing (OLTP) database system to an online analytical processing (OLAP) database system that is located on a second SQL Server 2000 computer.You want the package to execute automatically each evening at 8:00 P.M. What should you do?

正确答案 ：A

Use SQL Server Enterprise Manager to create a new job Create a CmdExec job step that runs the dtsrun utility Schedule the job to run each night at 8:00 P.M.

解析：解析：Explanation: Transfers can be defined and stored in a DTS package, which can then be run from a command line using the dtsrun utility (DTSRUN.EXE). CmdExec job steps are operating system commands or executable programs ending with .bat, .cmd, .com, or .exe. In this scenario we create a job consisting of a single cmdexec job step which runs the DTS package using the dtsrun utility.

[单选题]You are the administrator of your company's network. A user named Paul in the service department has a Windows 2000 Professional computer. Paul needs to access the files that are in a shared folder on his computer. A local group named Sales has permissions to access the data. Paul is a member of the Sales local group but he cannot access the file he needs.What should you do?

正确答案 ：C

Remove Paul from any other group that has been explicitly denied access to the Sales folder.

解析：解析：Explanation: The Sales group, which Paul is a member of, has permission to access the files. However, Paul still cannot access the files. It would seem that Paul has a permissions conflict. A user can be granted file permissions in a number of contexts: as a user or as a member of a user group. When a user has different file permissions in multiple contexts, the most restrictive permission is applied. Furthermore, the deny permission overrides all other permissions. As Paul does not have access to the file you must therefore assume Paul has explicitly been denied access to the file in some context, as member of one or more groups that have been denied access to the file. You would thus have to remove Paul from such a group so that the restriction is not applied to Paul.

[多选题]You need to install Windows 2000 Server on one of your older Windows NT Server 4.0 computers. The server has dual processors, 2 GB of RAM, a RAID controller with five SCSI hard disks in an array, and a generic 10/100-MB network adapter. You begin the server installation by updating the SCSI firmware.You then start the installation of the Windows 2000 Server operating system. During the next portion of the installation, you receive an error message indicating that no hard disks can be found.

正确答案 ：DG

Restart the installation by using the Windows 2000 Installation CD-ROM. Press F6 during the text-mode setup.

Insert a disk with the OEM SCSI driver.

解析：解析：Answer: B, E

[单选题]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.

查看原题