首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of SQL Server 2000 computer named FABSQL2K01. You create a Data Transformation Services package that c
You are the administrator of SQL Server 2000 computer named FABSQL2K01. You create a Data Transformation Services package that c
admin
2009-05-19
72
问题
You are the administrator of SQL Server 2000 computer named FABSQL2K01. You create a Data Transformation Services package that contains definition for two transform data tasks.
The tasks gets data from two text files named Customers and Sales. The DTS package is configured as shown in the exhibit.
You do not want the DTS package to add any data to the server unless both transform data tasks complete successfully.
You select the use transactions check box of DTS package and the Join transaction of present check box of both transform data tasks. You then select the fail package on step failure check box of both transform data tasks.
You want to use the DTS package to import data from the text files to the server. You want to ensure that changes are committed if all imported data is successfully transformed.
What should you do?
选项
A、Select the commit on successful completion check box of the DTS package.
B、Select the commit transaction on successful completion of this step check box of the customers transform data task.
C、Select the commit transaction on successful completion of this step check box of the sales transform data task.
D、Select the commit transaction on successful completion of this step check box of both transform data tasks.
答案
A
解析
Explanation: It is possible to set the Commit on successful package completion check box on the Advanced Tab of the DTS Properties dialog Box. This check box specifies that if each individual SQL statement is a transaction completes successfully, the transaction will automatically be committed; and if the statement has an error, the statement is rolled back.
When this check box is cleared, the DTS connections operate in implicit transaction mode and the first SQL statement begins a transaction that remains in effect until DTS commits it or rolls it back. The next SQL statement executed after any commit or rollback starts a new transaction.
Incorrect Answers:
B: The Commit transaction on successful completion of this step check box treats each step in a DTS package as separate. Thus, selecting the Commit transaction on successful completion of this step check box of the customers transform data task would result in this task being committed regardless of the progress of the sales transformation data task.
C: The Commit transaction on successful completion of this step check box treats each step in a DTS package as separate. Thus, selecting Commit transaction on successful completion of this step check box of the sales transform data task would result in this task being committed regardless of the progress of the customer’s transformation data task.
D: The Commit transaction on successful completion of this step check box treats each step in a DTS package as separate. Thus, select the commit transaction on successful completion of this step check box of both transform data tasks would result in the two parts being treated as separate and each part being committed regardless of the progress in the other.
转载请注明原文地址:https://kaotiyun.com/show/2uhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
[A]Marketforglasscraftsisgrowing[B]Dependenceofcomputerdevelopmentonglass[C]Behindtheadaptabilityofglass[D]
[A]Enduringproblemssuchaswar,poverty,andviolenceultimatelyspringfromhumannature,whichnotechnologicalinnovation
[A]Enduringproblemssuchaswar,poverty,andviolenceultimatelyspringfromhumannature,whichnotechnologicalinnovation
Fewthingssay"forgetI’mhere"quitesoeloquentlyastheposeoftheshy—theavertedgaze,thehunchedshoulders,thebodypi
Supposeyouarethepersonnelmanagerofacompanyandyou’vedecidedtheapplicantnamedZhangWeiisthebestcandidateforth
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
Herearesomemanagementtoolsthatcanbeusedtohelpyouleadapurposefullife.1.UseYourResourcesWisely.Yourdecisi
"Thisisareallyexcitingtime—aneweraisstarting,"saysPeterBazalgette,thechiefcreativeofficerofEndemol,thetelev
Americanfarmershavebeencomplainingoflaborshortagesforseveralyearsnow.Givenamulti-yeardeclineinillegalimmigrati
随机试题
Tobeagoodteacher,youneedsomeofthegiftsofagoodactor,youmustbeableto【C1】______theattentionandinterestofyou
原发性高血压最常见的并发症是
小儿患风痧,证见高热,口渴,心烦不宁,小便黄少,舌红,苔黄糙,治疗原则是
《尚书》认为五行中为"百姓之所饮食"者是《尚书》认为五行中为"百姓之所兴作"者是
如图4-40所示,绳子的一端绕在滑轮上,另一端与置于水平面上的物块B相连,若物B的运动方程为X=KT2,其中k为常数,轮子半径为R,则轮缘上A点的加速度的大小为()。
消防控制设备应具备的功能有()。
十进制数字32的BCD码为:
根据资源税法律制度的规定,下列各项中,属于资源税征税范围的有()。
生物链指的是由动物、植物和微生物互相提供食物而形成的相互依存的链条关系。这种关系在大自然中很容易看到。生物链也可以理解为自然界中的食物链,它形成了大自然中“一物降一物”的现象,维系着物种间天然的数量平衡。根据上述定义,下列不属于生物链的是(
在SQL的ALTERTABLE语句中,为了增加一个新的字段应该使用短语()。
最新回复
(
0
)