首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are a database administrator in the Los Angeles branch office of a specialty foods supplier. A mainframe database at the hea
You are a database administrator in the Los Angeles branch office of a specialty foods supplier. A mainframe database at the hea
admin
2009-05-19
7
问题
You are a database administrator in the Los Angeles branch office of a specialty foods supplier. A mainframe database at the headquarters contains all company data. Each branch office contains a SQL Server 2000 computer that imports regional data from the mainframe database.
The server in Los Angeles contains a Data Transformation Services (DTS) package that uses OLE DB to connect to the company’s mainframe database. The DTS package extracts and transforms data about buyers and products for that region. The DTS package then writes the data to the SQL Server database in Los Angeles.
You need to configure a SQL Server computer for the new branch office in Sydney. You want to copy the Los Angeles package and modify it so that it writes data to the SQL Server database in Sydney.
You use the DTS Designer to modify the DTS package so that it imports regional data from the mainframe database to the server in Sydney. The modified DTS package runs successfully on the server in Los Angeles. You save this DTS package to the server in Sydney, but the server in Sydney cannot connect to the mainframe database.
You want to enable the server in Sydney to connect to the mainframe database. What should you do?
选项
A、Change the connection properties in the DTS package so that the package uses new login credentials to connect to the mainframe database.
B、Modify the workflow in the DTS package so that the server in Sydney is included.
C、On the server in Sydney, install an OLE DB provider for the mainframe database.
D、On the server in Sydney, delete and then re-create the DTS package.
答案
C
解析
Explanation: OLE DB is an API that allows COM applications to use data from OLE DB data sources, which includes data stored in different formats. An application uses an OLE DB provider to access an OLE DB data source. An OLE DB provider is a COM component that accepts calls to the OLE DB API and performs the necessary processing required by request against the data source. In this scenario the OLE DB source is the company’s mainframe database, which contains all company data. As each branch office contains a SQL Server 2000 computer that imports regional data from the mainframe database, all existing and future branch office SQL Server 2000 servers will require an OLE DB provider to access the company’s mainframe database.
Incorrect Answers:
A: The DTS package requires an OLE DB provider to access an OLE DB data source. It needs this provider to connect to the company’s mainframe database. Resetting the connection properties in the DTS package so that the package uses new login credentials to connect to the mainframe database will not provide the DTS package with the required access to the mainframe database.
B: A separate DTS package must be created for the Sydney branch office. This DTS package must extract data from the company’s mainframe computer that is relevant to the branch office in Sydney. The existing DTS package used to extract data from the company’s mainframe for the Los Angeles SQL Server 2000 server can be modified to serve the same function for the Sydney office.
D: Re-creating the DTS package on the SQL Server 2000 server in the branch office in Sydney is unnecessary the that SQL Server 2000 server would still require an OLE DB provider to access the company’s mainframe database. It would require less administrative effort to modify the existing DTS package.
转载请注明原文地址:https://kaotiyun.com/show/5uhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
BarackObamaspentmuchtimeonthecampaigntrailproposingadramaticvisiontochangenotonlytheUnitedStatesforthebett
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
MireilleGuiliano,achampagnecompanyexecutive,capturedtheattentionoffrustrateddieterswithherjoyoflifeinthe2005
Itstartedsmall.Justapoliticalslogan,pastedontoaposterinabackofficesomewhere;NOEUROin1999.Germany’smainoppo
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
InToday’smanagement-theoryindustry,reputation—oratleastthecorporatekind—isa"strategicasset"thatcanbe"leveraged"
NextmonthBritonswillhaveyetmoresmartphonestochoosefrom,whendevicesfromWiko,atwo-year-oldFrenchcompany,goons
NextmonthBritonswillhaveyetmoresmartphonestochoosefrom,whendevicesfromWiko,atwo-year-oldFrenchcompany,goons
GivingmillionsofexistingPayPalcustomerstheabilitytobuyattheclickofabuttonhasenormouspotentialforincreasing
随机试题
某网络上传输模拟信号时采用PCM编码,若在该网络信道上传送8000Hz以下频率的声音信号,每个样本采用256级量比,计算该信道的最小数据传输率。(要求写出计算过程)
阅读曹雪芹《宝玉挨打》中的文字:宝钗见他睁开眼说话,不像先时,心中也宽慰了好些,便点头叹道:“早听人一句话,也不至今日。别说老太太、太太心疼,就是我们看着,心里也——”刚说了半句又忙咽住,自悔说的话急了,不觉的就红了脸,低下头来。请回
慢性肺心病缓解期可有下列哪些表现
谷类食品是我国居民膳食中能量、蛋白质及某些矿物质和B族维生素的主要来源。加工、烹调方法对谷类营养价值的影响很大。加工精白来(面)时损失最多的营养素是()
关于新生儿病理性黄疸的特点哪项是正确的
男,76岁。慢性阻塞性肺疾病病史30年,3天前受凉后出现寒战、高热、咳嗽、咳胶冻状血痰,伴右侧胸痛。查体:T39.5℃,R28次/分,口唇发绀,双肺呼吸音减弱,右上肺可闻及湿哕音,胸部X线片示右上肺大片状模糊影。该患者最可能的诊断是()
物业保险的目的是利于善后工作和()。
如果两个朋友已相识多年,他们之向的感情必然非常——:有时亲密无间,有时形同陌路。潮起潮落,甘甜苦涩。我们如何平静地对待这些起起落落,直接影响到友谊的——。填入划横线部分最恰当的一项是()。
根据下列资料,回答问题。为了解消费者对家电使用的满意度情况,某家电零售企业民意中心选取了20个销售网点的2000位居民进行调查。调查显示,受访消费者中23.4%表示“满意”,40.2%表示“基本满意”。其具体调查结果见下表。各类家电中,表示
设A=,B为三阶非零矩阵,a1=,a2=,a3=。为BX=0的解向量,且AX=a3有解.(Ⅰ)求常数a,b.(Ⅱ)求BX=0的通解.
最新回复
(
0
)