2. 计算机
  3. You are the administrator of a SQL Server 2000 computer. You are creating a data transformation services package. As the first s

You are the administrator of a SQL Server 2000 computer. You are creating a data transformation services package. As the first s

admin2009-05-19  66
问题 You are the administrator of a SQL Server 2000 computer. You are creating a data transformation services package. As the first step in this process, you need to load data from text files into a database table. These text files contain data on new stores that join your franchise. The text files list the data columns in the following format StoreID, StoreName, Address, City, State, PostalCode, ManagerID, StoreTypeID, FacilityID.

The destination table is configured as shown in the exhibit.


You want to load the data into the table as quickly as possible. What should you do?
选项 A、Use a Bulk Insert Task to read the data into a temporary table. Use an Execute SQL task to import the appropriate data into the destination table.
B、Create and edit a format file to select the columns you want to import. Use a Bulk Insert Task, and then specify the format file to import the appropriate data into the destination table.
C、Use a transform data task to import the data. Use Microsoft ActiveX transformation scripts to write the appropriate data to the appropriate columns in the destination table.
D、Create and edit a format file to select the columns you want to import. Use a transform data task, and then specify the format file to import the appropriate data into the destination table.
答案B
解析 Explanation: The Bulk Insert Task is the fastest mechanism for copying large amounts of data into a SQL Server 2000 table or view. However, transformations cannot be performed on the data while it is moved from the source file to the table or view, as this would slow down the data copy process. Thus the text file must be formatted before the Bulk Insert Task is used.

The format file provides the default information used either to bulk copy the data in the data file into an instance of SQL Server 2000 or to bulk copy data out from the table. The format file also provides a way to bulk copy data selectively from a data file to an instance of SQL Server. This allows for the transfer of data to a table when there is a mismatch between fields in the data file and columns in the table. By using a format file, it is possible to bulk copy data into an instance of SQL Server without having to add or delete unnecessary data, or reorder existing data, in the data file.

Incorrect Answers:
A: The Bulk Insert Task is the fastest mechanism for copying large amounts of data into a SQL Server 2000 table or view. It can make use of a format file that allows for the transfer of data to a table when there is a mismatch between fields in the data file and columns in the table. By using a format file, it is possible to bulk copy data into an instance of SQL Server without having to add or delete unnecessary data, or reorder existing data, in the data file. It thus makes the need to first import the data into a temporary table obsolete.

C: The Transform Data task is used to copy data between a source and destination and to optionally apply column-level transformations to the data. The Transform Data task is the most basic implementation of the data pump engine in Data Transformation Services (DTS) and is optimized for insert-based copying and transforming of column-level data between commercial databases, spreadsheets, and text files. However, the Bulk Insert task provides the best performance for bulk inserting text files into SQL Server 2000, although it cannot be used to transform data.

D: The Bulk Insert Task is the fastest mechanism for copying large amounts of data into a SQL Server 2000 table or view. It can make use of a format file that allows for the transfer of data to a table when there is a mismatch between fields in the data file and columns in the table. By using a format file, it is possible to bulk copy data into an instance of SQL Server without having to add or delete unnecessary data, or reorder existing data, in the data file.
转载请注明原文地址:https://kaotiyun.com/show/NuhZ777K
本试题收录于： 微软70228题库微软认证分类
0

微软70228

微软认证

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