首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
38
问题
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://www.kaotiyun.com/show/5uhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
[A]"Ijustdon’tknowhowtomotivatethemtodoabetterjob.We’reinabudgetcrunchandIhaveabsolutelynofinancialrewa
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
Herearesomemanagementtoolsthatcanbeusedtohelpyouleadapurposefullife.1.UseYourResourcesWisely.Yourdecisi
MireilleGuiliano,achampagnecompanyexecutive,capturedtheattentionoffrustrateddieterswithherjoyoflifeinthe2005
TheU.S.PostalService(USPS)continuestobleedredink.Itreportedanetlossof$5.6billionforfiscal2016,the10thst
Evenintraditionaloffices,"thelinguafrancaofcorporateAmericahasgottenmuchmoreemotionalandmuchmoreright-brained
Adealisadeal—except,apparently,whenEntergyisinvolved.Thecompany,amajorenergysupplierinNewEngland,provokedjus
InToday’smanagement-theoryindustry,reputation—oratleastthecorporatekind—isa"strategicasset"thatcanbe"leveraged"
通过【网上邻居】查找网上计算机和共享文件资源,IP为“202.204.54.23”,主机名为administrator,共享文件夹名为“tools”。
Emilyislisteningtonetworktrafficandcapturingpasswordsastheyaresenttotheauthenticationserver.Sheplanstouseth
随机试题
在设计组织结构时,大型的钢铁企业适用于()
肺炎链球菌肺炎患者咳铁锈色痰主要见于哪一病理分期
用治寒凝血瘀,月经不调,少腹冷痛,当选的性味是
现金流量折现法与传统方法的主要区别()。
某钻井平台设置了逃生装置,包括两组钢丝绳;每组钢丝绳的一端固定在井架平台上,另一端连接到安全区域的沙坑内锚定,则该钻井平台采取的技术手段属于()。
当某企业的产量为2个单位时,其总成本、总固定成本、总可变成本、平均成本分别是2000元、1200元、800元和1000元;当产量为3个单位时,其总成本、总固定成本、总可变成本、平均成本分别是2100元、1200元、900元和700元,则该企业的边
在一个支付公司所得税的世界里,财务困境成本与代理成本的存在如何影响MM理论。
被判处管制的犯罪分子和在缓刑考验期内的犯罪分子应当共同遵守的规定包括()。
国务院总理李克强2013年10月9日下午在文莱首都斯里巴加湾市出席第十六次中国一东盟(10+1)领导人会议。李克强总理在会议上发表讲话,指出中国与东盟关系已进入成熟期,中国与东盟合作步人快车道,双方应把握机遇,推动中国——东盟宽领域、深层次、高水平、全方位
A、Lossofawareness.B、Lossofmemory.C、Excessiveanxiety.D、Lowspirits.B讲座提到,阿尔茨海默病(Alzheimer’s)不仅对那些遭受记忆丧失(sufferfrommemo
最新回复
(
0
)