从银行提取现金业务一方面引起了现金的增加，另一方面引起了银行存款的减少，故应编制现金收款

A．DM数据迁移工具DTS可跨平台实现数据库之间的数据和结构互导

B． DTS可实现DM数据库与文本文件之间的数据或者结构互导

C． DTS无法支持迁移过程中的数据类型转换

D． 在迁移的过程中它最大限度地保留了源数据的原始信息

plier. A mainframe. database at the headquarters contains all company data. Each branch office contains a SQL Server 2000 computer that imports regional data from the mainframe. database.

The server in Los Angeles contains a Data Transformation Services (DTS) package that uses OLE DB to connect to the company's mainframe. database. The DTS package extracts and transforms data about buyers and products for that region. The DTS package then writes the data to the SQL Server database in Los Angeles.

You need to configure a SQL Server computer for the new branch office in Sydney. You want to copy the Los Angeles package and modify it so that it writes data to the SQL Server database in Sydney.

You use the DTS Designer to modify the DTS package so that it imports regional data from the mainframe. database to the server in Sydney. The modified DTS package runs successfully on the server in Los Angeles. You save this DTS package to the server in Sydney, but the server in Sydney cannot connect to the mainframe. database.

You want to enable the server in Sydney to connect to the mainframe. database. What should you do？

A．Change the connection properties in the DTS package so that the package uses new login credentials to connect to the mainframe. database.

B．Modify the workflow in the DTS package so that the server in Sydney is included.

C．On the server in Sydney, install an OLE DB provider for the mainframe. database.

D．On the server in Sydney, delete and then re-create the DTS package.

A．导入和导出数据

B． 转换数据

C． 复制数据库对象

D． 创建数据库对象

, you perform. database maintenance tasks. You create a Data Transformation Services package to populate the data warehouse. MAPI is not installed on the server.

You want to schedule the DTS package to run each night. You want to attend to other duties while the DTS package is executing. You also want to be notified if the DTS package fails.

What should you do？

A．Select the DTS packages log package execution to SQL server check box. Create a SQL server event alert to notify you if the package fails.

B．Select the DTS packages write completion status to event log check box. Create a SQL server event alert to notify you if the package fails.

C．Configure the DTS package to include an on failure precedence constraint and a send mail task. Configure the send mail task to notify you if the package fails.

D．Configure the DTS package to include an on failure precedence constraint and a send mail task. Configure the execute process task to execute a not send command that will notify you if the package fails.

_______不是数据迁移工具。

A．HP OpenView

B．Oracle Warehouse Builder

C．Informix InfoMover

D．Microsoft SQL Server DTS

A．数据迁移

B．DDL操作

C．数据同步

D．数据修改

E．数据订阅