首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
admin
2009-05-19
89
问题
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
微软认证
相关试题推荐
AlmosteveryyearsincetheendofthefinancialcrisishasstartedwithrosyexpectationsamongAmericanforecasters,andthis
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
Herearesomemanagementtoolsthatcanbeusedtohelpyouleadapurposefullife.1.UseYourResourcesWisely.Yourdecisi
"Thisisareallyexcitingtime—aneweraisstarting,"saysPeterBazalgette,thechiefcreativeofficerofEndemol,thetelev
MenorcaorMajorca?Itisthattimeoftheyearagain.Thebrochuresarepilingupintravelagentswhilenewspapersandmagazin
MenorcaorMajorca?Itisthattimeoftheyearagain.Thebrochuresarepilingupintravelagentswhilenewspapersandmagazin
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
InToday’smanagement-theoryindustry,reputation—oratleastthecorporatekind—isa"strategicasset"thatcanbe"leveraged"
设置网络打印机,不允许每个连接到该计算机的用户都使用该网络打印机,只允许用户Administrators和Powerusers使用本地打印机。
Emilyislisteningtonetworktrafficandcapturingpasswordsastheyaresenttotheauthenticationserver.Sheplanstouseth
随机试题
反常性碱性尿
在X线摄影中,使用对比剂可以增加组织间的对比,有助于形成影像。肝肾功能严重受损不能进行静脉尿路造影检查的原因不包括
氨基酸脱氨基可生成相应的α-酮酸,后者在体内参与合成
下列有关金融中介与金融市场功能的关系的表述,传统理论认为()。
我国最早修筑长城的是(),大约始于公元前7世纪中叶。
人体的免疫功能,可清除自身的损伤细胞,在这一生理过程中,损伤细胞属于()。
君子博学而日参省乎己,_______。(《荀子.劝学》)
公安部不需要接受中央政法委员会的领导,但是各级地方公安机关要接受各级党委的政法委员会的领导。()
交管局要求司机在通过某特定路段时,在白天也要像晚上一样使用大灯,结果发现这条路上的年事故发生率比从前降低了15%。他们得出结论说:如果在全市范围内都推行该项规定会同样地降低事故发生率。以下哪项如果为真,最能支持上述论证的结论?
Tobefrank,IshouldsayTom______(与其说是个摄影师,不如说是个画家).
最新回复
(
0
)