首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of a SQL Server 2000 computer. The server contains a Data Transformation Services (DTS) package that q
You are the administrator of a SQL Server 2000 computer. The server contains a Data Transformation Services (DTS) package that q
admin
2009-05-19
28
问题
You are the administrator of a SQL Server 2000 computer. The server contains a Data Transformation Services (DTS) package that queries multiple databases and writes the results to a text file. You run this package by using a Microsoft Windows batch file. The batch file uses the dtsrun utility to execute the DTS package.
You want to ensure that connection properties, such as login names and passwords, cannot be read or modified by users. Which two actions should you take? (Each correct answer represents part of the solution. Choose two.)
选项
A、Save the DTS package so that it has an owner password.
B、Save the DTS package so that it has a user password.
C、Encrypt the DTS package details in the command line of the dtsrun utility.
D、Store the DTS package in the Meta Data Services repository.
E、Store the DTS package as a Microsoft Visual Basic file.
答案
A,C
解析
Explanation: In this scenario we will use a windows batch file with the owner password for maximum security.
A: When running the Dtsrun utility on a package you must either specify a user password or a package password. Specify a password for the package to protect sensitive user name and server password information in the package from unauthorized users with owner password. If the package has an owner password, the data is encrypted with the standard encryption API. This protects protect sensitive user name and server password information in the package from unauthorized user.
.
C: You can encrypt the command prompt options to be executed by the DTS Run utility, allowing you to create an encrypted dtsrun command for later use. This will ensure that login names, password and other command line options cannot be read or modified by users.
Note: When a package is saved to SQL Server or as a structured storage file, DTS package passwords can be assigned to the package. These passwords are used in addition to the Windows Authentication or SQL Server Authentication passwords to connect to an instance of SQL Server.
There are two types of DTS package passwords that can be set: an owner password and a user password. If an owner password is set, the package user needs the password to edit or run the package and if a user password is set, the package users with access to the user password can run the package.
Incorrect Answers:
B: There is no need to create a user password. The package will be run with an owner password. The owner password will be protected since the command options are encrypted.
D: The Meta Data Services repository is the storage container for the meta data used by Analysis Services. Meta data is stored in tables in a relational database and is used to define the parameters and properties of Analysis server objects. DTS package information can be saved to Meta Data Services. This saves meta data information about the databases referenced in the package, which can be viewed though the DTS Browser.
E: When a DTS package is saved as a Visual Basic file, these files can be used as templates, or starting points, for user-implemented Visual Basic packages. The generated code sets all properties of all objects referenced in the package to the initial values they will have when package execution begins. This includes those that are set to their default values.
转载请注明原文地址:https://jikaoti.com/ti/owO7FFFM
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
Climatechangeissupposedtounfoldslowly,overdecades.Butthatisnottrueupinthegreatwhitenorth,asthoseattending
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
[A]"Ijustdon’tknowhowtomotivatethemtodoabetterjob.We’reinabudgetcrunchandIhaveabsolutelynofinancialrewa
BarackObamaspentmuchtimeonthecampaigntrailproposingadramaticvisiontochangenotonlytheUnitedStatesforthebett
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
Herearesomemanagementtoolsthatcanbeusedtohelpyouleadapurposefullife.1.UseYourResourcesWisely.Yourdecisi
Adealisadeal—except,apparently,whenEntergyisinvolved.Thecompany,amajorenergysupplierinNewEngland,provokedjus
GivingmillionsofexistingPayPalcustomerstheabilitytobuyattheclickofabuttonhasenormouspotentialforincreasing
随机试题
吸虫的中间宿主A.水生植物B.牛、羊C.淡水鱼、虾D.猫E.溪蟹
左旋多巴治疗帕金森病的机制是:
患儿,9岁。血液检查显示:Hb64g/L;Hct25%;RBC3.20×1012/L。根据上述资料该患儿的贫血属于
投标文件的技术性评审包括()。
Excel2003中属于文本型数据的是()。
股权投资基金管理人内部控制,是指股权投资基金管理人为防范和化解风险,保证各项业务的合法合规运作,实现经营目标,在充分考虑内外部环境的基础上,对经营过程中的风险进行识别、评价和管理的制度安排、组织体系和控制措施。下列选项中,不属于管理人内部控制作用的是(
下列哪些属于制裁后的教育管理工作?()
简述发展心理学的研究领域。
Crueltytoanimals,itissaid,isoftenaprecursortogravercrimes.Sowouldtherenotbesomeusefulnesstoaregistryofin
Accordingtothepassage,somepeople’simpressionofsealsisthat______.Welearnfromthesecondparagraphthat______.
最新回复
(
0
)