首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
90
问题
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
微软认证
相关试题推荐
Inthe1930s,anAmericanmeatcompanycameoutwithaspicedhamproductsoldinacan.Beforelong,Spam,asitwascalled,be
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
Evenbeforetheopeningceremony,arecordhadbeenbrokenatSochi:12newevents,themostforanyOlympics,werescheduledto
School-agechildrenshouldparticipatein60minutesormoreofmoderatetovigorousphysicalactivitydaily,accordingtoanex
Writealettertoacompanydecliningajoboffer.Inyourletter,youshouldappreciatethejoboffer,andstateyourreason(s)
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
Whethertheeyesare"thewindowsofthesoul"isdebatable;thattheyareintenselyimportantininterpersonalcommunicationis
Evenintraditionaloffices,"thelinguafrancaofcorporateAmericahasgottenmuchmoreemotionalandmuchmoreright-brained
Bobisanewsecurityadministratoratafinancialinstitution.Theorganizationhasexperiencedsomesuspiciousactivityonone
随机试题
男性,55岁,患慢性肾炎10余年。经中西医结合治疗病情稳定,但近1年来逐渐加重,食欲下降,贫血,化验血肌酐已进入肾衰竭期,这时血肌酐的水平是
胃短动脉起源于
我国《选举法》中规定,省、自治区的人民代表大会代表的名额,由本级人民代表大会常务委员会按照农村每一代表所代表的人口数四倍于城市每一代表所代表的人口数的原则分配。当前,有人对该规定提出了质疑,认为它违反了宪法上的平等原则,也有人认为该规定是合理的。请你运用法
下列()是国有土地使用权取得的方式。
物业管理企业控制财务预算的目的是()。
(2008年案例分析30)甲于1990年10月犯诈骗罪被判处无期徒刑,2004年3月被假释。2006年5月,甲通过互联网得知某单位有钢材销售后,与乙商量,要乙扮作自己的助手,携带款项前往洽谈生意。在甲与该单位谈判中,乙一直在场。经谈判,双方签订合同,合同约
在数据文件的非主属性上建立的索引称为______。A)稀疏索引B)聚集索引C)稠密索引D)辅助索引
窗体上有1个名称为Textl的文本框;1个名称为Timerl的计时器控件,其Interval属性值为5000,Enabled属性值是True。Timerl的事件过程如下:PrivateSubTimerl_Timer()S
OxfordandCambridgeUniversityBoatClubshavebothtakentheopportunitytotraveltoSpainthismonthtotraininlesstestin
SittinginabackroomatLondon’sBarbicanartscenter,whichishostingtheGameOnExhibition,HenryJenkinsdeliversaline
最新回复
(
0
)