首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
58
问题
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://jikaoti.com/ti/kVO7FFFM
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
[A]Thefirststepinpreparingamarketingplanisthatofproducingtheinformationnecessaryfordecision-making.Usually,a
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
Writeanessaybasedonthechart.Inyourwriting,youshould1)describethediagram,and2)giveyourcomments.
TheStudents’UnionofyourdepartmentisplanningaChineseSpeakingContest.Writeanannouncementwhichcoversthefollowing
Forthefirsttime,GeorgeBushhasacknowledgedtheexistenceofsecretCIAprisonsaroundtheworld,wherekeyterroristsuspe
DespiteincreasedairportsecuritysinceSeptember11th,2001,thetechnologytoscanbothpassengersandbaggageforweaponsan
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
Themethodsoftestingaperson’sknowledgeandabilityremainasprimitiveasevertheywere.Afteralltheseyears,education
MusicfanshaveoftenviewedMicrosoftassomethinglikeabadcoverband,onethatpumpedoutuninvitingfacsimilesofApple’s
Superiorcustomerservicecanbeanessentialsourceofstrengthascompaniesemergefromtherecession,butmanagersneedtoun
随机试题
倒车雷达不工作怎么办?
急淋血病首选治疗药物是
A.降压药B.利尿剂C.细胞毒药物D.抗生素E.血液透析急性肾炎出现下肢高度浮肿
A.处三年以上十年以下有期徒刑B.处十五年有期徒刑C.处七年以下有期徒刑D.处二年以上七年以下有期徒刑E.处二年以下有期徒刑生产者、销售者在产品中以假充真,销售金额五十万元以上不满二百万的
患者临床诊断为肺炎,咳铁锈色痰,最有可能的致病菌是()。
槽型预埋件的加工精度要求不允许有负偏差的项目有()。
某企业年初从银行贷款100万元,期限1年,年利率为10%,按照贴现法付息,则年末应偿还的金额为()万元。
下列不属于内部控制目标的是()。
下列对于学习方式中的合作学习描述正确的是()
新单亲子女是指父母一方在外地工作的孩子,虽然生活在健全的家庭,但因为长期不能和父亲或母亲团聚,得不到应有的照顾,又缺乏相互间的交流,造成孩子的情感缺失。根据上述定义,下列属于新单亲子女的是:
最新回复
(
0
)