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

[单选题]Ezonexam has 50 offices. The employees in these offices have limited knowledge of Windows 2000. Each office has a network of between five and 20 client computers. The office networks are connected to each other. The company is buying 50 identical computers to run Windows 2000 Server in these offices. The server must be installed to the company's standard configuration. You use Setup Manager to create a network shared distribution folder and a Unattend.txt file that specifies the company's standard configuration.You want to automate the installation process as much as possible, in the least possible amount of time.

正确答案 ：C

Create a Microsoft MS-DOS network boot disk that makes a connection to the network shared distribution folder and runs the winnt command with the /s and /u switches. Instruct an employee at each office to start the installation by using this disk.

解析：解析：Explanation:Winntandnotwinnt32asthebootdisksoperateinDOSmodeandworkswith16-bitapplications.The/s:pathswitchspecifiesthelocationoftheinstallationfilesforWindows2000Server.The/u:fileswitchspecifiesthelocationoftheanswerfileforunattendedinstallationsandthenumberofsecondstowaitbetweencopyingthefilesandrestartingthecomputer.SincetheemployeeshavelimitedknowledgeinsofarasWindows2000isconcerned,itwouldbebesttomakeuseofthewinntcommand-linewiththeabovementionedswitches.Incorrectanswers:A:ThisoptionpresupposesthattheemployeeswhowillbetaskedwiththeinstallationhaveasoundknowledgeofWindows2000.C,D:ThisoptionwouldbeproblematicsincetheemployeeshavelimitedknowledgewhenitcomestoWindows2000.

查看原题 查看所有试题