首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
60
问题
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
微软认证
相关试题推荐
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
[A]"Ijustdon’tknowhowtomotivatethemtodoabetterjob.We’reinabudgetcrunchandIhaveabsolutelynofinancialrewa
AlmosteveryyearsincetheendofthefinancialcrisishasstartedwithrosyexpectationsamongAmericanforecasters,andthis
WhentheresidentsofBuenosAireswanttochangethepesostheydonottrustintothedollarstheydo,theygotoacueva,or"
Supposeyouarethepersonnelmanagerofacompanyandyou’vedecidedtheapplicantnamedZhangWeiisthebestcandidateforth
MireilleGuiliano,achampagnecompanyexecutive,capturedtheattentionoffrustrateddieterswithherjoyoflifeinthe2005
MireilleGuiliano,achampagnecompanyexecutive,capturedtheattentionoffrustrateddieterswithherjoyoflifeinthe2005
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
随机试题
A、刺激外周化学感受器B、刺激中枢化学感受器C、直接作用于呼吸中枢D、刺激肺牵张感受器E、刺激脑桥调整中枢动脉血中二氧化碳分压升高引起呼吸加强的主要机制是()
胸膜腔内少量浆液的作用是
A.人际传播B.大众传播C.组织传播D.自我传播E.水平传播职业性信息传播机构和人员通过广播、电视、报纸、期刊等媒介,向范围广泛、为数众多的社会人群传递信息的过程,属于
下列属于水利水电工程初步设计阶段施工组织设计文件的内容的是()。
下列选项中,不属于经典条件反射现象的是()。
案例:在关于讲授“计算机硬件”部分知识的课堂上,张老师对“计算机被打开之后”,将板书设计为两种,一种是传统板书,是纯文字提纲样式的计算机硬件组成图;另一种是多媒体板书,把组成图中的部分文字用图片代替。张老师开始进行教学设计时,使用的是传统板书,后来经过
edu既可以做顶级域名,又可以做二级域名。()
某市政府发布文件规定,外地物流公司到本地运输货物,应事前得到当地交通管理部门的准许.并缴纳道路特别通行费。下列说法错误的是()。
心脏搏动引起血液循环。同一个人,心率越快,单位时间内进入循环的血液量越多,血液中的红细胞运输氧气就越多。一般地说,一个人单位时间内通过血液循环获得的氧气越多,他的体能发挥就越佳,为了提高运动员在体育比赛中的竞技水平,应该加强他们在高海拔地区的训练,因为在高
Allentitiesandindividualsinvolvedintransactionsthatdirectlyaffectbalanceofpaymentsmustreportdataforcompilation
最新回复
(
0
)