首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
109
问题
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
微软认证
相关试题推荐
[A]Thefirststepinpreparingamarketingplanisthatofproducingtheinformationnecessaryfordecision-making.Usually,a
Afterthedotcomboomofthe1990s,theworldisabouttoexperienceaboomindots.Over1,000newgenerictop-leveldomainnam
Directions:Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressy
Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressyourownopinion.
Theideaisasaudaciousasitaltruistic:provideapersonallaptopcomputertoeveryschoolchild—particularlyinthepoorestp
Inthe2006filmversionofTheDevilWearsPrada,MirandaPriestly,playedbyMerylStreep,scoldsherunattractiveassistant
BedwettingMillionsofkidsandteenagersfromeverypartoftheworldwetthebedeverysinglenight.It’ssocommonthatt
Superiorcustomerservicecanbeanessentialsourceofstrengthascompaniesemergefromtherecession,butmanagersneedtoun
Parentsarenottheonlyonesresponsiblefortheirchildren.Oursocialresponsibilityisatitsgreatestwhenparentsareunab
Thefollowingscenariowillbeusedforquestions29and30.Johnisanetworkadministratorandhasbeentoldbyoneofhisnet
随机试题
什么是成本性态?成本按性态可以划分为几种类型?
老年患者术后贫血,合并心功能不全,输入哪种血制品最合适()
肺癌常见的症状是
《药品管理法》适用于
甲向乙借款500万元,丙提供了保证担保,丁提供了抵押担保。请根据民法原理、《合同法》《担保法》回答下列问题:设甲、乙之间的借款合同为有效合同。甲到期无力还款,乙要求丙承担保证责任,丙主张物保优于人保,其主张是否符合法律规定?为什么?
已知甲公司上年的净经营资产净利率为37.97%,税后利息率为20.23%,净财务杠杆为0.46;今年的销售收入为10000万元,税前经营利润为4000万元,利息费用为600万元,平均所得税率为30%,今年年末的其他有关资料如下: 要求:计算今年的
以下在风险评估程序中运用分析程序的说法中,错误的是()。
A、 B、 C、 D、 B
交换机按()分类,可以分为固定端口交换机与模块式交换机。
ApersonbecomespartoftheChristiancommunitythroughbaptism--itisamatterofchoice【C1】______birth.TheChristiancommun
最新回复
(
0
)