首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
69
问题
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
AlmosteveryyearsincetheendofthefinancialcrisishasstartedwithrosyexpectationsamongAmericanforecasters,andthis
Twomonthsago,yougotajobasaconsultantforHumanResourceServiceCompany.Butnowyoufindthattheworkisnotwhatyou
Youliveinaroomincollegewhichyousharewithanotherstudent.Youfinditverydifficulttoworktherebecauseyourroomma
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
"Thisisareallyexcitingtime—aneweraisstarting,"saysPeterBazalgette,thechiefcreativeofficerofEndemol,thetelev
LastThursday,theFrenchSenatepassedadigitalservicestax,whichwouldimposeanentirelynewtaxonlargemultinationalst
Notlongago,chiefexecutiveofficers(CEOS)werelandedasheroes,leadersofthebraveneweconomy.BillGatesandJackWelchw
TheoutbreakofswinefluthatwasfirstdetectedinMexicowasdeclaredaglobalepidemiconJune11,2009.Itisthefirstwo
随机试题
要扩充政府活动,首先应就其________进行仔细认真的研究。
November7,2000isaveryspecialdayintheUnitedStates.Votersallacrossthenationare【21】representativesinlocalandnat
下列符合公司治理基本特征的有()。
用人单位与本单位职工签订集体合同或专项集体合同,以及确定相关事宜,应当采取()的方式。
当企业的业务都实现计算机化后,那些从事计算机业务的企业却遭遇了_______。如果需要计算机化的业务流程没有增加,顾客对性能没有特别需求,他们就无法继续_______自己的产品。所以,所有与计算机相关的企业,都必须为已经得到满足的顾客们,提供一个购买他们更
虎门销烟:《南京条约》
某地区居民生活用水每月标准用水量的基本价格为每吨3元,若每月用水量超过标准用水量,超出部分按基本价格的130%收费。某户六月用水25吨,共交水费83.1元,则该地区每月标准用水量为:
民族精神是一个民族在长期共同生活和社会实践中形成的,为本民族大多数成员所认同的价值取向、思维方式、道德规范、精神气质的总和。在五千多年的发展中,中华民族形成了伟大的民族精神。民族精神的核心是()
二进制数11011101转换为十进制数是()。
在μC/OS—II中有多种方法可以保护任务之间的共享数据和提供任务之间的通信。其中不能达到保护目的的方法是()。
最新回复
(
0
)