首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
18
问题
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
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
WhentheresidentsofBuenosAireswanttochangethepesostheydonottrustintothedollarstheydo,theygotoacueva,or"
Writeanessayof160-200wordsbasedonthefollowingtable.Youressayshould1.describethechangesintheaveragefamilyex
Supposeyouarethepersonnelmanagerofacompanyandyou’vedecidedtheapplicantnamedZhangWeiisthebestcandidateforth
BarackObamaspentmuchtimeonthecampaigntrailproposingadramaticvisiontochangenotonlytheUnitedStatesforthebett
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
MireilleGuiliano,achampagnecompanyexecutive,capturedtheattentionoffrustrateddieterswithherjoyoflifeinthe2005
InToday’smanagement-theoryindustry,reputation—oratleastthecorporatekind—isa"strategicasset"thatcanbe"leveraged"
随机试题
急腹症病人最主要的临床表现是【】
设f(x)在[0,+∞)上连续,f(0)=0,f’’(x)在(0,+∞)内恒大于零,证明g(x)=在(0,+∞)内单调增加.
下列"阴虚"虚劳治疗选方中不准确的是
在设计前期工作中应预估工程设计费的投入情况,下列收费组成中,哪项是不正确的?[2003-43]
为了保证GPS网一定的几何强度,国标中对各等级GPS多边形网与附合导线网的边数做出限制,就C级网而言边数应()。
内部牵制制度是指凡是涉及款项和财物收付、结算及登记的任何一项工作,必须由两人或两人以上分工办理,以起到相互制约作用的一种工作制度。下列各项中,关于内部牵制制度的说法中,正确的是()。
中国人民银行的职能不包括()。
库存物资ABC分类管理中,下列观点表述正确的是()。
D注册会计师负责对丁公司20X4年度财务报表进行审计。在审计银行存款时,D注册会计师遇到下列事项,请代为作出正确的专业判断。丁公司某银行账户的银行对账单余额为1585000元,在检查该账户银行存款余额调节表时,D注册会计师注意到以下事项:在途存款1
维果茨基提出的关于教育和教学的重要问题不包括()。
最新回复
(
0
)