首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of a SQL Server 2000 computer. Your company uses the server to store service contract information for
You are the administrator of a SQL Server 2000 computer. Your company uses the server to store service contract information for
admin
2009-05-19
10
问题
You are the administrator of a SQL Server 2000 computer. Your company uses the server to store service contract information for its customers.
You are also the administrator of Oracle relational database management system (RDBMS) server.
This server is used to store your company’s financial information. The financial information is updated frequently throughout the day.
You need to create a series of reports that combine the service contract information and the financial information. These reports will be updated several times a day.
You want to create reports on the SQL Server computer by using the minimum amount of disk space.
What should you do?
选项
A、Set up SQL server replication to replicate the data from the oracle server to the SQL server computer.
B、Set up the oracle server as a linked server. Create a view that joins the service contract information and the financial information.
C、Set up data transformation services (DTS) package that imports and transforms the database from the oracle server to the SQL server computer. Use SQL server agent to execute the DTS package throughout the day as needed.
D、Set up Microsoft ActiveX script that connects to the oracle server and imports the financial information into SQL server temporary table. Create a view that joins the service contract information and the temporary table.
答案
B
解析
Explanation: SQL Server 2000 permits the creation of links to OLE DB data sources called linked servers. After linking to an OLE DB data source, it is possible to reference rowsets from the OLE DB data sources as tables in Transact-SQL statements and to pass commands to the OLE DB data sources and include the resulting rowsets as tables in Transact-SQL statements.
Each distributed query can reference multiple linked servers and can perform either update or read operations against each individual linked server. A single distributed query can perform read operations against some linked servers and update operations against other linked servers. The Microsoft OLE DB Provider for Oracle allows distributed queries to query data in Oracle databases.
Incorrect Answers:
A: Replication allows for the coping, distribution, and modification of data across an enterprise. This involves the copying of database data from one server to another. This is not the best solution in this scenario as this will require frequent replication because the reports must be updated several times a day.
C: Data Transformation Services is a set of graphical tools and programmable objects that allows for the extraction, transformation, and consolidation of data from disparate sources into single or multiple destinations. In this scenario, however, the Oracle database needs to be included in a query. Hence, Data Transformation Services are inappropriate.
D: Microsoft ActiveX scripts can be used to add functionality to Data Transformation Services packages, which is a set of graphical tools and programmable objects that allows for the extraction, transformation, and consolidation of data from disparate sources into single or multiple destinations. In this scenario, however, the Oracle database needs to be included in a query. Hence, Data Transformation Services are inappropriate.
转载请注明原文地址:https://kaotiyun.com/show/brhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
Fastingglucose(葡萄糖)andinsulin(胰岛素)levelsremainwithinnormalrangeforwomenusinginjectableororalcontraception,withonl
Cancerisusedgenericallyformorethan100differentdiseases,includingmalignanttumoursofdifferentsites,suchasbreast,
Writealettertothedepartmentconcerned,askingittohelpfindacharitableprojectsuitableforallstudentsinyouruniver
Youruniversityisgoingtoholdareadingcontest.Writeanoticetoprovidethestudentswhowouldliketoattendwithrelevan
Writealettertoacompanydecliningajoboffer.Inyourletter,youshouldappreciatethejoboffer,andstateyourreason(s)
Artificialheartshavelongbeenthestuffofsciencefiction.In"Robocop",snazzycardiacdevicesaremadebyYamahaandJense
Artificialheartshavelongbeenthestuffofsciencefiction.In"Robocop",snazzycardiacdevicesaremadebyYamahaandJense
Conversationsaboutelderlyparentsandtechnologyusuallycenteronsafety,inparticularondevicesdesignedtoalertacallc
Conversationsaboutelderlyparentsandtechnologyusuallycenteronsafety,inparticularondevicesdesignedtoalertacallc
Insectsaredisappearing.Theworldhas25percentfewerterrestrialinsectsnowthanin1990.Thisincludesthosewerelyon
随机试题
A.以呕吐为早期主要症状B.以腹痛为主要临床表现C.两者皆有D.两者皆无结肠梗阻
关于电子束CT的描述,错误的是
丹毒的致病菌是
根据我国企业破产法的规定,下列属于企业破产原因的是()。
根据《票据法》的规定,下列选项中,属于禁止背书转让汇票的情形有()。
“路怒族”是近来出现比较多的名词,指汽车驾驶员带着愤怒去开车。最近,因为“路怒”导致了多起交通事故或刑事案件的发生。对此,甲乙两人进行了评论。甲:“路怒”成为导致交通事故的新的现象,主要就是因为驾驶员的心态不好。驾驶员需要控制自己的情绪,在以后的驾驶员考
BSP方法所使用的C/U矩阵不能刻画信息系统的()。
要使得在“应用程序生成器”中所做修改与当前活动项目保持一致,应单击【】按钮;
Whattimedoestheman’splaneleave?
Globalizationisthepresentworldwidedrivingtowardaglobal-【M1】______izedeconomicsystemdominatedbysupranationalcorpo
最新回复
(
0
)