2. 计算机
  3. You are the administrator of a SQL Server 2000 computer. You create a Data Transformation Services (DTS) package. The package is

You are the administrator of a SQL Server 2000 computer. You create a Data Transformation Services (DTS) package. The package is

admin2009-05-19  37
问题 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.
B、Use SQL Server Enterprise Manager to create a new job
Create a Transact-SQL job step to query data from the OLTP database
Create a second Transact-SQL job step to launch the DTS package
Schedule the job to run each night at 8:00 P.M.
C、Create a batch file that runs the dtsrun utility
Use the Microsoft Windows Task Scheduler to run the job each night at 8:00 P.M.
Configure the Windows Task Scheduler to use the local system account
D、Move the DTS package to the repository
Configure the SQLServerAgent service on the OLAP database server to update the package each night at 8:00 P.M.
答案A
解析 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.

Incorrect answers:
B: Only one job, not two, has to be created at the OLTP database server.

C: If the Task Scheduler is running as the local system account it wouldn’t be able to access the remote OLAP database server.

D: The DTS export package should be run at the OLTP database server, not at the OLAP database server. The DTS package is exported from the OLTP server to the OLAP server.
转载请注明原文地址:https://kaotiyun.com/show/IrhZ777K
本试题收录于： 微软70228题库微软认证分类
0

微软70228

微软认证

相关试题推荐
随机试题
最新回复(0)