首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
35
问题
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
微软认证
相关试题推荐
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
[A]Marketforglasscraftsisgrowing[B]Dependenceofcomputerdevelopmentonglass[C]Behindtheadaptabilityofglass[D]
School-agechildrenshouldparticipatein60minutesormoreofmoderatetovigorousphysicalactivitydaily,accordingtoanex
Itishardtomakemoneypeddlingsocialmediaanywhere.Duringtheirfirstfewyearsinbusiness,FacebookandTwitterlostpo
WhentheresidentsofBuenosAireswanttochangethepesostheydonottrustintothedollarstheydo,theygotoacueva,or"
Youliveinaroomincollegewhichyousharewithanotherstudent.Youfinditverydifficulttoworktherebecauseyourroomma
LastThursday,theFrenchSenatepassedadigitalservicestax,whichwouldimposeanentirelynewtaxonlargemultinationalst
Adealisadeal—except,apparently,whenEntergyisinvolved.Thecompany,amajorenergysupplierinNewEngland,provokedjus
设置网络打印机,不允许每个连接到该计算机的用户都使用该网络打印机,只允许用户Administrators和Powerusers使用本地打印机。
随机试题
有助于扩张型心肌病与慢性肺源性心脏病鉴别的是
诊断支气管哮喘的主要依据是
超声的纵向分辨率是分辨前后两个点最小距离的能力,其理论计算值应是
原发性肝癌最常见的首发症状是
某男,57岁,一年来,频生白发,兼有遗精早泄、头眩耳鸣等症状,经医师诊断为肝肾不足所致,宜选用()。
下列何种国家侵权行为不能适用消除影响、恢复名誉、赔礼道歉的责任方式?()
会计机构负责人、会计主管人员移交时,必须将全部财务会计工作、重大财务收支和会计人员的情况等,向接替人员详细介绍。对需要移交的遗留问题,应当写出书面材料。()
经批准,股份有限公司在发行B股时,可以与承销商在包销协议中约定超额配售选择权。()
甲:今天早上我开车去上班时,被一警察拦住,并给我开了超速处罚单。因为当时在我周围有许多其他的车开得和我的车一样快,所以很明显那个警察不公平地对待我。乙:你没有被不公平地对待,因为很明显那个警察:不能拦住所有超速的司机。在那个时间、那个地点
ThePacificOceancoversmorethan166millionsquarekilometers(morethan64millionsquaremiles)--aboutone-thirdoftheea
最新回复
(
0
)