正确答案: 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.
题目：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?
解析：解析：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 a SQL Server 2000 computer. The server contains a Data Transformation Services (DTS) package that queries multiple databases and writes the results to a text file. You run this package by using a Microsoft Windows batch file. The batch file uses the dtsrun utility to execute the DTS package.You want to ensure that connection properties, such as login names and passwords, cannot be read or modified by users. Which two actions should you take? (Each correct answer represents part of the solution. Choose two.)
Save the DTS package so that it has an owner password.
Encrypt the DTS package details in the command line of the dtsrun utility.
解析：解析：Explanation: In this scenario we will use a windows batch file with the owner password for maximum security.
[单选题]You are upgrading a computer from Windows 98 to Windows 2000 Professional. The computer is a 400-Mhz Pentium III, and has 128 MB of RAM and a 10-GB hard disk. You are performing the installation by using the Windows 2000 Professional CD-ROM. After the text mode installation portion is complete, you restart the computer. The BIOS virus checker on your computer indicates you're your computer is infected with a Master Boot Record virus.What should you do before you continue the installation?
Disable the BIOS virus checker and restart the computer.
解析：解析：Explanation: During the installation of Windows 2000, the setup program must make changes the boot sector. The BIOS virus checker interprets changes made to the boot sector as the result of a virus and prevents the computer from booting any further. You must therefore disable the BIOS virus checker.
[单选题]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'.
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.
[单选题]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.
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.
[单选题]You are the desktop administrator for Ezonexam.com'ssalesdepartment. Ezonexam.com's network contains a RIS server.You need to install Windows 2000 Professional on a computer that has a SCSI disk subsystem. You start the computer by using the Windows 2000 Professional CD-ROM, and you begin the installation.
Start the computer by using the Windows 2000 Professional CD-ROM, and run Setup. After Setup starts, provide a SCSI-controller driver on a floppy disk.
解析：解析：Explanation: The problem here is that Windows 2000 doesn't have a driver for the SCSI-controller and so can't find a hard disk to install onto. We can solve this problem by providing a driver during the installation. During the text mode part of the installation, you will see the option to "Press F6 to install a third party SCSI driver".
[多选题]计算机指令一般包括操作码和地址码两部分，为分析执行一条指令，其 （1）
操作码和地址码都应存入指令寄存器。
操作码和地址码都应存入程序计数器
解析：答案：（1）C
试题解析：
指令寄存器（IR）用来保存当前正在执行的一条指令。当执行一条指令时，先把它从内存取到数据寄存器（DR）中，然后再传送至IR。指令划分为操作码和地址码字段，由二进制数字组成。为了执行任何给定的指令，必须对操作码进行测试，以便识别所要求的操作。指令译码器就是做这项工作的。指令寄存器中操作码字段的输出就是指令译码器的输入。操作码一经译码后，即可向操作控制器发出具体操作的特定信号。
[单选题]You are the network administrator for Ezonexam.The network includes a Windows 2000 Server computer that contains a single 36-GB hard disk. The drive is configured as a basic disk and has two partitions. Partition C is 4 GB in size and contains the operating system files. Partition D is 32 GB in size and contains user data that is updated frequently.
Start the computer by using a Windows 2000 Server compact disc. Select the Repair option in Setup.
解析：解析：Explanation:Therearefourwaystoperform.anattendedinstallation:1.BoottoaCD-ROM,therebyinvokingthesetuproutine.2.BoottoacurrentoperatingsystemwithCD-ROMsupportandmanuallyinvokethesetuproutine.3.BoottoasetoffoursetupdisksandthenprovidetheCD-ROMwhenprompted.4.Boottoanetwork-awareoperatingsystemandinvokesetupoverthenetwork.IfyouhaveacomputerwhoseBIOSsupportsbootingfromaCD-ROM,youcansetupWindows2000Serverwithoutinstallinganoperatingsystemonyourharddriveandwithoutrequiringnetworksupport.Todoso,configureyourcomputertoboottotheCD-ROMintheBIOS.IntheabovescenariotheserverfailedandforyoutorecovertheserverasquicklyaspossibleandrecoveringasmuchdataaspossibleyouneedtousetheWindows2000ServerCDandselecttheRepairoptioninSetup.Incorrectanswers:B:Thisoptionwillnotbethebesttofollowiftheserveristoberecoveredwithintheshortestpossibletime.Youwillalsolosesomedatasincere-creatingthesharedfoldersonthefirstharddiskwouldalreadyhavedatamissingsincePartitionCiscorrupted.C:EmergencyRepairDiskenablesyoutorecoverfromRegistrysettingsthatrenderyoursysteminoperable.ThismightbemisconfigurationthatcouldnotbecaughtwiththeLastKnownGoodConfiguration,oritmightbedeleteduseraccountsorotherRegistrychanges.Thisisnotaregistryproblem.TheEmergencyRepairDiskcanbeusedtofacilitatesomesystemrepairsonyourWindows2000server.Essentially,thediskcanbeusedtorepairstartupproblems,likewhenessentialstartupfilesarenotpresentandyourServerrefusestoboot.However,thisproblemneedstobeaddressesasquicklyaspossibleandmakinguseoftheRepairoptioninSetupfromtheWindows2000ServerCDwouldbethequickermethod.D:TheRecoveryconsoleisapowerfultext-basedbootalternativeforWindows2000Server.Ifyoursystembecomessocorruptthatitwillnotbootandnootherrepairprocesswillhelp,youcanboottotheRecoveryconsoleandcopyfilestoorfromyourserver.Inaddition,youcanstopandstartservices,ifaservicethatyouhaveinstalledcausesproblemswithbooting.Thisoptiondoesnotrepresentthequickestwaytoaddresstheproblemathand.
