2. 计算机
  3. You are a database administrator in the Los Angeles branch office of a specialty foods supplier. A mainframe database at the hea

You are a database administrator in the Los Angeles branch office of a specialty foods supplier. A mainframe database at the hea

admin2009-05-19  26
问题 You are a database administrator in the Los Angeles branch office of a specialty foods supplier. 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.
答案C
解析 Explanation: OLE DB is an API that allows COM applications to use data from OLE DB data sources, which includes data stored in different formats. An application uses an OLE DB provider to access an OLE DB data source. An OLE DB provider is a COM component that accepts calls to the OLE DB API and performs the necessary processing required by request against the data source. In this scenario the OLE DB source is the company’s mainframe database, which contains all company data. As each branch office contains a SQL Server 2000 computer that imports regional data from the mainframe database, all existing and future branch office SQL Server 2000 servers will require an OLE DB provider to access the company’s mainframe database.

Incorrect Answers:
A: The DTS package requires an OLE DB provider to access an OLE DB data source. It needs this provider to connect to the company’s mainframe database. Resetting the connection properties in the DTS package so that the package uses new login credentials to connect to the mainframe database will not provide the DTS package with the required access to the mainframe database.

B: A separate DTS package must be created for the Sydney branch office. This DTS package must extract data from the company’s mainframe computer that is relevant to the branch office in Sydney. The existing DTS package used to extract data from the company’s mainframe for the Los Angeles SQL Server 2000 server can be modified to serve the same function for the Sydney office.

D: Re-creating the DTS package on the SQL Server 2000 server in the branch office in Sydney is unnecessary the that SQL Server 2000 server would still require an OLE DB provider to access the company’s mainframe database. It would require less administrative effort to modify the existing DTS package.
转载请注明原文地址:https://kaotiyun.com/show/5uhZ777K
本试题收录于： 微软70228题库微软认证分类
0

微软70228

微软认证

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