首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of a SQL Server 2000 computer. You create a Data Transformation Services (DTS) package. The package is
You are the administrator of a SQL Server 2000 computer. You create a Data Transformation Services (DTS) package. The package is
admin
2009-05-19
103
问题
You are the administrator of a SQL Server 2000 computer. You create a Data Transformation Services (DTS) package. The package is stored as a local package on the server. The package exports data from an online transaction processing (OLTP) database system to an online analytical processing (OLAP) database system that is located on a second SQL Server 2000 computer.
You want the package to execute automatically each evening at 8:00 P.M. What should you do?
选项
A、Use SQL Server Enterprise Manager to create a new job
Create a CmdExec job step that runs the dtsrun utility
Schedule the job to run each night at 8:00 P.M.
B、Use SQL Server Enterprise Manager to create a new job
Create a Transact-SQL job step to query data from the OLTP database
Create a second Transact-SQL job step to launch the DTS package
Schedule the job to run each night at 8:00 P.M.
C、Create a batch file that runs the dtsrun utility
Use the Microsoft Windows Task Scheduler to run the job each night at 8:00 P.M.
Configure the Windows Task Scheduler to use the local system account
D、Move the DTS package to the repository
Configure the SQLServerAgent service on the OLAP database server to update the package each night at 8:00 P.M.
答案
A
解析
Explanation: Transfers can be defined and stored in a DTS package, which can then be run from a command line using the dtsrun utility (DTSRUN.EXE). CmdExec job steps are operating system commands or executable programs ending with .bat, .cmd, .com, or .exe. In this scenario we create a job consisting of a single cmdexec job step which runs the DTS package using the dtsrun utility.
Incorrect answers:
B: Only one job, not two, has to be created at the OLTP database server.
C: If the Task Scheduler is running as the local system account it wouldn’t be able to access the remote OLAP database server.
D: The DTS export package should be run at the OLTP database server, not at the OLAP database server. The DTS package is exported from the OLTP server to the OLAP server.
转载请注明原文地址:https://kaotiyun.com/show/IrhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
Rao’s,thelegendaryeastHarlemItalianeatery,ismorethanahundredblocksaboveWallStreet.Butwithaclientelethatincl
Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressyourownopinion.
Directions:Writeanessaybasedonthechart.Inyourwriting,youshould1)interpretthechart,and2)giveyour
Writealettertoacompanydecliningajoboffer.Inyourletter,youshouldappreciatethejoboffer,andstateyourreason(s)
DespiteincreasedairportsecuritysinceSeptember11th,2001,thetechnologytoscanbothpassengersandbaggageforweaponsan
Theroughguidetomarketingsuccessusedtobethatyougotwhatyoupaidfor.Nolonger.Whiletraditional"paid"mediasuchas
UsingFacebookmakespeoplesadder,atleastaccordingtosomeresearch.Burjustwhatisitaboutthesocialnetworkthattakes
Guest账户和Administrator账户一样是由系统建立的,不能被禁用。
随机试题
汽车吊车及其他轮式专用机械车___。
具有温经养血,散寒通脉功用的方剂是具有益气活血,散瘀通络功用的方剂是
A.风寒表证B.脚气肿痛C.疥癣湿疮D.肺燥咳嗽苦楝皮可用治
某五星级宾馆工程项目,地下2层,地上21层,建设单位委托一家监理单位进行施工招投标阶段及施工阶段的监理工作。总监理工程师在主持编写监理规划中风险管理的有关内容时,预计可能产生的风险事件有:(1)通货膨胀;(2)承包单位挂靠,技术、管理水平低
2013年8月,中国证监会在对甲上市公司(以下简称“甲公司”)进行例行检查中,发现甲公司存在以下事实: (1)2013年1月,甲公司拟与乙公司进行400万元的交易。经查,乙公司持有甲公司6%的股份,该交易未经独立董事认可,即提交了甲公司董事会进行讨论表
1929-1933年经济危机发生后,美国罗斯福政府对经济实施全面干预政策。这里“干预”的本质含义是()。
制度化教育出现的标志是()
设备的重置成本,是指评估时点再获得与评估对象相同或相似全新设备的取得成本。()
Aftermorethan30yearsofrapidgrowth,Chinahasreachedanotherturningpointinitsdevelopmentpathwhenasecondstrategi
求极限:
最新回复
(
0
)