[单选题]Exhibit:UPDATE EzonexamConsolidated

正确答案 ：K

To enable updates on the composite tables create an INSTEAD OF trigger on the view.

解析：解析：Explanation:SQLServer2000usesINSTEADOFtriggersandpartitionedviewstoenhancetheclassofupdateableviews.INSTEADOFtriggerscanbecreatedonaviewinordertomakeaviewupdateable.TheINSTEADOFtriggerisexecutedinsteadofthedatamodificationstatementonwhichthetriggerisdefined.Thistriggerallowstheusertospecifythesetofactionsthatneedtotakeplaceinordertoprocessthedatamodificationstatement.Thus,ifanINSTEADOFtriggerexistsforaviewonagivendatamodificationstatement,thecorrespondingviewisupdateablethroughthatstatement.Iftheviewisapartitionedview,theviewisupdateable,subjecttocertainrestrictions.IncorrectAnswers:A:Creatingatablethatcombinesthecompositetablesthattheviewisbasedonwoulddenyustheabilitytousetheviewtoreturnaggregatedcolumnvalues.B:Theerrormessageisnotrelatedtopermissionsbuttotheupdateableofthetable.D:CascadingreferentialintegrityconstraintsmakesitpossibletodefinetheactionsSQLServer2000takeswhenauserattemptstodeleteorupdateakeytowhichexistingforeignkeyspoint.CascadingreferentialintegrityconstraintsfireAFTERtriggersafterallofthecascadingreferentialactionsdirectlycausedbytheoriginalDELETEorUPDATEareperformed.

[单选题]You need to install Windows 2000 Professional on 300 computers for a customer company called Ezonexam. The computers have different manufacturers and different hardware abstraction layers (HALs). You plan to use a Windows 2000 Server computer running Remote Installation Services (RIS) to perform. the installation.After the installation is complete for the first 25 computers, users of those computers report problems. You discover that the latest Windows 2000 service pack resolves those problems.

正确答案 ：E

Slipstream the service pack into a new i386 distribution shared folder, and then run the Risetup command to create a new CD-based image for the RIS server.

解析：解析：Explanation:YoucanuseRisetup.exetocreateaCD-ROM-basedRISimagewithaservicepackslipstreamed.Thisistheprocedure:1.CopythecontentsoftheWindows2000ProfessionalCD-ROMtoasharedfolderonaserver(oralocalfolderontheRISserver).2.FromtheWindows2000servicepacksourcefiles,runtheupdate-s:foldercommandtoslipstreamthesourcefileswiththeservicepack.3.Whentheslipstreamingprocessisfinished,runRisetup.exeontheRISservertoaddanewimagetotheserver.Whenyouarepromptedforthelocationofthefiles,typethepathtotheslipstreamedshareyoucreatedinsteps1and2.IncorrectAnswersA:Thisproposedsolutionwouldnotworkbecausethecomputershavedifferenthardware.Forthisreason,wemustuseaCD-basedimage.B:WearegoingtoinstallWindows2000Professionalcomputers;wecannotuseaRISimageofaWindows2000ServercomputerC:JustcopyingtheServicePacktotheCD-basedimagesharedfolderwouldnotapplyit.

[单选题]Your company network includes 6,000 Windows 2000 Professional client computers and 35 Windows 2000 Server computers in a single domain.Your company has a print device that is used to print payroll checks. The print device is physically attached to the parallel port of one of the client computers. This print device's tray is loaded with checks at all times. You have shared this printer on the network as ChkPrinter and retained the default permissions.

正确答案 ：F

Configure ChkPrinter to allow the HRserv domain account print permissions for ChkPrinter. Remove print permissions for the Everyone group.

解析：解析：Explanation:TheprintapplicationisrunasaserviceaccountintheHRservdomain.Bygrantingthisaccountprintpermissions,andremovingprintpermissionsfortheEveryonegroup,onlythepayrollapplicationwillbeabletousetheprinter.Incorrectanswers:A:BychangingthesharenametoChkPrinter$thenamewouldbehidden,butitcouldstillbeusedbyeveryone,sincetheEveryonegroupgetsprintpermissionsbydefault.B:Restrictingtheavailabletimewillnotpreventusersfromusingtheprinterwhenitisavailable.Theapplicationwouldnotbeabletousetheprinterduringthetimesitisconfiguredtobeunavailable.D:IftheEveryonegroupisdeniedprintpermissionontheprinter,noteventheapplicationwouldbeabletousetheprinter.

[单选题]You are the administrator of a Windows 2000 Professional computer that has a shared printer. Several departments in your company use the shared printer.The Sales department frequently prints multiple-page presentation graphics, which take a long time to print. Users in other departments who have short messages to print must wait an unnecessarily long time for their jobs to print.

正确答案 ：D

Configure the priority of the printer to 50. Add a new printer, and set the priority to 99. For the new printer, deny print permissions for users in the Sales department.

解析：解析：Explanation: The Sales department has long-running printing jobs that are blocking the print device for long periods of time. In order to give the other departments' print jobs higher priority than the Sales department's print jobs, we create a new printer with higher priority. We deny print permission for the Sales department on the new printer.

[多选题]You want to upgrade a Windows NT Server 4.0 computer named Server34 to Windows 2000 Server. Server34 is a member server in a Windows 2000 domain named marketing.fabrikam.local. The domain runs in native mode.You want to change the role of Server34 from a member server to a domain controller in the same domain. What should you do? (Choose Two)

正确答案 ：BC

D

in the marketing domain.

解析：解析：Explanation: To upgrade a Windows NT 4.0 member server to a Windows 2000 Domain Controller we must first upgrade the Windows NT 4.0 member server to Windows 2000 Server and then install Active Directory Services through the Active Directory Installation Wizard, which can be started with the DCPROMO.EXE command or by the Configure Your Server utility in Administrative tools.

[单选题]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 network administrator for Ezonexam.Your Windows 2000 Server computer named Ezonexam1 contains two 36-GB hard disks. Disk 0 and Disk 1. Each disk is configured as a basic disc and has a single 36-GB NTFS partition. Both partitions are backed up to a tape each night. The partition on Disk 1 stores user data. Most users at Ezonexam encrypt their files. Disk 1 fails. You replace it with a new hard disk and create a single NTFS partition.

正确答案 ：E

Restore the contents of Disk 1 from the most recent tape backup to the new partition on Ezonexam1. Instruct the users to verify the integrity of their files.

解析：解析：Explanation:VerifyDataAfterBackupisusedtoconfirmthatfilesarecorrectlybackedup.WindowsBackupcomparesthebackupdataandthesourcedatatoverifythattheyarethesame.Microsoftrecommendsthatyouselectthisoption.RestoringthecontentsofDisk1fromthemostrecentbackuptapetothenewpartitiononEzonexam1andinstructingtheuserstoverifytheintegrityoftheirfileswouldaccomplishthetaskathandthequickestandstillmaintainthesecurityofthefilesofDisk1.Incorrectanswers:A:Thereisnoneedtomakeuseofasecondfileserver.Thiswillnotaccomplishthetaskasquickaspossible.Besides,thisdoesnotmeanthatthesecurityonthefileswillbekeptintact.B:Thereisnoneedtomakeuseofasecondfileserver,neitherasarecoveryagentandthencopyingfilesfromthesecondfileservertothenewpartition.Thiswilltaketoolonginthiscase.D:Thefirstpartofthisoptioniscorrect;buttheciphercommandisusedtodecryptfiles.

[多选题]You are the administrator of a SQL Server 2000 computer. You want to set up snapshot replication on the server. The server will serve as Publisher and Distributor for a minimum of 40 Subscribers.Currently, you want to publish 3GB of data, but the data is expected to grow over time. Subscribers will receive a new snapshot each month.

正确答案 ：DE

Store the snapshot in a shared folder on a file server.

Create pull subscriptions.

解析：解析：Explanation:

[多选题]You are the administrator of several SQL Server 2000 computers. A data Transformation Services (DTS) package uses native OLE DB providers to transfer data between the servers. Connection details for the servers are specified in .udl files. The .udl files are frequently updated as connection details change.You want to distribute the DTS package as a file to developers in your company. You want to make sure connection details are available to developers who receive the DTS package.

正确答案 ：BF

Enable the Always read properties from UDL file option in the Connection Properties dialog box.

Make the .udl files available on a network share.

解析：解析：Explanation:

[单选题]A folder on your Windows 2000 Professional computer contains bitmap files that have been compressed from 2MB to 1MB. You want to copy one of the compressed bitmap files from the hard disk to 1.4-MB floppy disk.When you attempt to copy, you receive the following error message 'Destination drive is Full'.

正确答案 ：D

Use another program to compress the bitmap file before copying it to the floppy disk.

解析：解析：Explanation: Windows 2000 file compression only works on the NTFS file system. However, floppy disks make use of the FAT file system. When compressed files are copied from an NTFS drive to a FAT or FAT32 drive, the file loses it compressed state and becomes uncompressed. You therefore require another application to compress the bitmap file. You could for example use Winzip, WinRar, WinAce or Micosoft's compress.exe.

查看原题