首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
94
问题
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
Thenewaircraftrepresentsa$250mbetbyBombardierthatMexicocouldprovidenotjustroutinelabourbutmanufacturingthat
Directions:Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressy
Whileyouwereawayfromhomeonbusinessafewdaysago,yourfatherfellintoacoma.YourneighborMarystoppedacarandbro
Youarethepresidentofacompany.WriteamemotoSallyCooper,theHRmanagerontheemployeestrainingoncomputerto,1
Herearesomemanagementtoolsthatcanbeusedtohelpyouleadapurposefullife.1.UseYourResourcesWisely.Yourdecisi
"Thisisareallyexcitingtime—aneweraisstarting,"saysPeterBazalgette,thechiefcreativeofficerofEndemol,thetelev
LastThursday,theFrenchSenatepassedadigitalservicestax,whichwouldimposeanentirelynewtaxonlargemultinationalst
DrRichardBergland,abrainresearcherattheHarvardMedicalSchool,haswrittenapapersuggestingthathumanbrainisbasica
TheoutbreakofswinefluthatwasfirstdetectedinMexicowasdeclaredaglobalepidemiconJune11,2009.Itisthefirstwo
随机试题
数据库系统中程序与数据之间的关系如图所示,图中★标记处对应的名称是________。
女性,30岁,发现右侧颈部肿大淋巴结2个月。体格检查:右侧胸锁乳突肌中下外侧扪及淋巴结1.5cm,质坚硬,甲状腺不肿大,无明确结节扪及,右侧颈淋巴结活检病理证实淋巴结转移癌,考虑来源于甲状腺可能性较大。下列哪一种诊断可能性较大
A.胃酸分泌正常,血清促胃液素↓B.胃酸分泌↓,血清促胃液素↑C.胃酸分泌↑,血清促胃液素↓D.胃酸分泌↓,血清促胃液素↓E、胃酸分泌↑,血清促胃液素↑下列疾病可引起上述哪种改变慢性萎缩性胃体胃炎
左室内压上升速度最快是在( )
患儿,8岁。因剑突下钻顶样疼痛伴恶心呕吐3小时就诊,患儿疼痛剧烈,哭闹不停,以“胆道蛔虫病”收治入院。经解痉止痛病情缓解后,医嘱予驱虫药左旋咪唑治疗。护士指导患儿正确服用驱虫药的时间为()
镇江市北固山上的多景楼,又名梳妆楼,相传是()出嫁前在此梳妆。
作为一种食用糖类,果糖已广泛运用到食品加工产业中。果糖在进人人体细胞后停留在血液中,它在人体中的代谢途径与胰岛素无关,人体摄入不会引起血糖及胰岛素水平的波动。所以,果糖对糖尿病病人血糖影响较葡萄糖小,糖尿病患者在摄入果糖后血糖升高不多。因此,果糖是一种对
InOctober2002,GoldmanSachsandDeutscheBank【C1】______anewelectronicmarketforeconomicindicesthat【C2】______substanti
Accordingtothestory,thegameofchesswasinventedbyan______.ThekingwasgladtoknowthatSissaonlywantedsomewhea
Readthearticlebelowaboutteam-building.Choosethecorrectwordtofilleachgap,fromA,BorC.Foreachquestion29-40,ma
最新回复
(
0
)