首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
78
问题
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
微软认证
相关试题推荐
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
Fewthingssay"forgetI’mhere"quitesoeloquentlyastheposeoftheshy—theavertedgaze,thehunchedshoulders,thebodypi
Writealettertooneofyourfriends,apologizingtohim/herforyourmakinghis/hercomputerstopworking.Youshouldwrite
Herearesomemanagementtoolsthatcanbeusedtohelpyouleadapurposefullife.1.UseYourResourcesWisely.Yourdecisi
MireilleGuiliano,achampagnecompanyexecutive,capturedtheattentionoffrustrateddieterswithherjoyoflifeinthe2005
Evenintraditionaloffices,"thelinguafrancaofcorporateAmericahasgottenmuchmoreemotionalandmuchmoreright-brained
Adealisadeal—except,apparently,whenEntergyisinvolved.Thecompany,amajorenergysupplierinNewEngland,provokedjus
InParagraphs1and2,thetextshowsPTK’s______.Skepticalobserversbelievethatancestrytestingfailsto______.
通过【网上邻居】查找网上计算机和共享文件资源,IP为“202.204.54.23”,主机名为administrator,共享文件夹名为“tools”。
随机试题
下列面谈的各自的基本目的是什么?①选择/聘用面试;②市场调查面谈;③与事故目击者的面谈;④绩效评估面谈;⑤销售面谈。
一男青年17岁,夜间突发右侧睾丸剧烈疼痛,有轻度咳嗽,无尿频,尿疼和尿急,来医院急诊检查,心肺(-),腹部检查未见异常,右侧睾丸较左侧略大,有明显触疼,阴囊无明显红肿,右附睾可及
成熟红细胞的主要供能代谢途径是
PM2.5是指直径
对化疗敏感的细胞
在给水管管材中,生产和消火栓消防给水管一般采用非镀锌钢管或()。
胡锦涛总书记在中共第十七次全国代表大会上作了重要报告。在报告中,他提及了关于社会主义文化建设的几个方面,主要有()。
设A为n阶矩阵,a0≠0,满足Aα0=0,向量组α1,α2满足Aα1=α0,A2α2=α0.证明α0,α1,α2线性无关.
Tothemajorityofus,musicisanindispensablepartofourdailylife.Itcanbedefinedinthisway,musicissoundarranged
ThenovelGulliver’sTravelsiswrittenby
最新回复
(
0
)