首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
54
问题
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
Writeanessayof160-200wordsbasedonthefollowingtable.Youressayshould1.describethechangesintheaveragefamilyex
Supposeyouorderedahairdryeronlineatthecostof$22,butonlyreceivedanemptypackagebox.Somethingmustbewrong.Wri
SupposeyouphonedyourfriendMaryseveraltimesyesterdaybutshedidn’tansweryourcallatall.Writeheranemailto1
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
NextmonthBritonswillhaveyetmoresmartphonestochoosefrom,whendevicesfromWiko,atwo-year-oldFrenchcompany,goons
随机试题
使用VC++2010打开考生文件夹下modil中的解决方案。此解决方案的项目中包含一个源程序文件modi1.c。在此程序中,函数fun()的功能是计算并输出k以内最大的10个能被13或17整除的自然数之和。k的值由主函数传入,若k的值为500,则函数的值
浸泡无菌持物钳的容器应是
由不同项目参与方的计划构成的进度计划系统包括( )。
检验检疫的作用体现在()。
下列关于个人贷款还款方式的描述,正确的有()。
选择古代哲学家经常采用的“假设两难情境”,编制“道德两难故事”,作为引发儿童道德判断的工具,研究儿童道德判断发展的心理学家是()。
根据表格回答问题:1996年~2000年中国旅游产业概况表1996年至2000年到中国旅游的外国人人次数是()。
简述解释助人行为的三种主要理论。
PASSAGETWO
IftwoscientistsatLosAlamosNationalLaboratoryarecorrect,peoplewillstillbedrivinggasoline-poweredcars50yearsfro
最新回复
(
0
)