首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
25
问题
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
Writeanessayof160-200wordsbasedonthefollowingdrawings.Inyouressay,youshould1)describethedrawingsbriefly,
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
LastThursday,theFrenchSenatepassedadigitalservicestax,whichwouldimposeanentirelynewtaxonlargemultinationalst
DrRichardBergland,abrainresearcherattheHarvardMedicalSchool,haswrittenapapersuggestingthathumanbrainisbasica
TheU.S.PostalService(USPS)continuestobleedredink.Itreportedanetlossof$5.6billionforfiscal2016,the10thst
Writealettertorecommendyourstudent,LiXu,forapositionofadministratorinacompany.Youshouldincludethedetailsyo
在用户管理组administrators中删除lusi用户。
随机试题
TIPSS方法的优点是
A.氨甲苯酸B.维生素CC.维生素KD.鱼精蛋白E.垂体后叶素
()是环境保护法的基础,是各种环境保护法律、法规、规章的立法依据。
信用货币是以信用为保证,通过一定信用程序发行的充当()的货币形态。
下列各项关于企业组织架构内部控制的表述中,错误的是()。(2016年)
________是为了完成共同目标的人群集合体,是按照一定目的和程序,人们进行分工和协作并在此基础上形成的一种责任和权力角色的结构系统。
儿童的思维运算已具有可逆性和守恒性,但思维运算还离不开具体事物的支持,说明儿童的认知发展所处的阶段是()。
甲、乙、丙、丁四个数的平均数是90,其中甲是乙的4倍,丙加上5、丁减去5后均等于乙的2倍,则丁等于:
Lookatthestatementsbelowandthearticleaboutmeetingsontheoppositepage.Whichsection(A,B,CorD)doeseachstate
Thelittlegirlshowednoanxietybeforethecompetition.Sheseemed______foritprettywell.
最新回复
(
0
)