首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of several SQL Server 2000 computers. A data Transformation Services (DTS) package uses native OLE DB
You are the administrator of several SQL Server 2000 computers. A data Transformation Services (DTS) package uses native OLE DB
admin
2009-05-19
28
问题
You are the administrator of several SQL Server 2000 computers. A data Transformation Services (DTS) package uses native OLE DB providers to transfer data between the servers. Connection details for the servers are specified in .udl files. The .udl files are frequently updated as connection details change.
You want to distribute the DTS package as a file to developers in your company. You want to make sure connection details are available to developers who receive the DTS package.
Which two tasks should you perform? (Each correct answer presents part of the solution. Choose two)
选项
A、Enable the Always read properties from UDL file option in the Connection Properties dialog box.
B、Disable the Always read properties from UDL file option in the Connection Properties dialog box.
C、Delete the .udl files and store connection details in the registry by using system data source names.
D、Delete the .udl files, and store connection details in the registry by using user data source names.
E、Make the .udl files available on a network share.
答案
A,E
解析
Explanation:
A: To make the connection information available for the developers we must enable the Always read properties from UDL file option.
E: We provide the developers with access to the .udl file by placing the .udl files in a network share and setting appropriate share and NTFS permissions.
Note: In SQL Server 2000, DTS packages can use Microsoft Data Link (.udl) files to create OLE DB connections and resolve the connections in run time. With this feature we can encapsulate the connection properties from a DTS package into a separate file and can edit the connection string in a .udl file instead of the connection properties in a DTS package in situations where connection information such as the server name, login, or even the OLE DB provider may change.
When specifying a data link connection, we must first specify whether to load an existing .udl file or create a data link to save with DTS Designer. If we want to use a .udl file rather than saving the data link with DTS Designer, we can create one either from Windows Explorer or during the data link configuration process in DTS Designer. We must then click Microsoft Data Link in the Data Source list of the Connection Properties dialog box and check the Always read properties from UDL file check box. In this scenario, the .udl file is already specified.
Incorrect Answers:
B: If we clear the Always read properties from UDL file option in the Connection Properties dialog box, we would have to edit the connection properties through the Data Transformation Services (DTS) package. This would increase administrative effort.
C: We cannot delete the .udl files and instead store the connection details in the registry by using system data source names as the connection details change regularly.
D: We cannot delete the .udl files, and instead store connection details in the registry by using user data source names as the connection details change regularly.
转载请注明原文地址:https://kaotiyun.com/show/MuhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
Climatechangeissupposedtounfoldslowly,overdecades.Butthatisnottrueupinthegreatwhitenorth,asthoseattending
[A]"Ijustdon’tknowhowtomotivatethemtodoabetterjob.We’reinabudgetcrunchandIhaveabsolutelynofinancialrewa
AlmosteveryyearsincetheendofthefinancialcrisishasstartedwithrosyexpectationsamongAmericanforecasters,andthis
Writeanessayof160-200wordsbasedonthefollowingtable.Youressayshould1.describethechangesintheaveragefamilyex
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
MireilleGuiliano,achampagnecompanyexecutive,capturedtheattentionoffrustrateddieterswithherjoyoflifeinthe2005
Adealisadeal—except,apparently,whenEntergyisinvolved.Thecompany,amajorenergysupplierinNewEngland,provokedjus
InToday’smanagement-theoryindustry,reputation—oratleastthecorporatekind—isa"strategicasset"thatcanbe"leveraged"
NextmonthBritonswillhaveyetmoresmartphonestochoosefrom,whendevicesfromWiko,atwo-year-oldFrenchcompany,goons
Writealettertorecommendyourstudent,LiXu,forapositionofadministratorinacompany.Youshouldincludethedetailsyo
随机试题
搭接接头的应力分布是不均匀的,其疲劳强度也低。()
鳖甲煎丸的功用是
心血管和外周血管造影现代的方法是
下列论述符合《互联网药品交易服务审批暂行规定》的有
下列关于房屋租赁的表述中,不正确的是()。
某座层高为3.2m的16层办公楼,无热水供应。每层设公共卫生间一个,每个卫生间设置带感应式水嘴的洗手盆4个、冲洗水箱浮球阀大便器6个、自动自闭式冲洗阀小便器3个、拖布池2个(q=0.2L/s)。每层办公人数为60人,每天办公时间按10h计,用水定额为40L
下列企业、组织中,不适用《中华人民共和国企业所得税法》的是()
根据下图,回答下列问题:下图给出了某国在2001~2004年间的国民生产总值、进出口额、平均收入、失业人数、部分时间工作岗位及通货膨胀率的发展情况。
在抗日战争时期,中国共产党开展延安整风运动最主要的任务是()。
利用变换y=f(ex)求微分方程y’’-(2ex+1)y’+e2xy=e3x的通解.
最新回复
(
0
)