首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
55
问题
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://kaotiyun.com/show/0uhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
AlmosteveryyearsincetheendofthefinancialcrisishasstartedwithrosyexpectationsamongAmericanforecasters,andthis
AlmosteveryyearsincetheendofthefinancialcrisishasstartedwithrosyexpectationsamongAmericanforecasters,andthis
WhentheresidentsofBuenosAireswanttochangethepesostheydonottrustintothedollarstheydo,theygotoacueva,or"
Writeanessayof160-200wordsbasedonthefollowingtable.Youressayshould1.describethechangesintheaveragefamilyex
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
MireilleGuiliano,achampagnecompanyexecutive,capturedtheattentionoffrustrateddieterswithherjoyoflifeinthe2005
Writealettertorecommendyourstudent,LiXu,forapositionofadministratorinacompany.Youshouldincludethedetailsyo
GivingmillionsofexistingPayPalcustomerstheabilitytobuyattheclickofabuttonhasenormouspotentialforincreasing
随机试题
女性,54岁,优秀话务员,近几年怀疑丈夫有外遇,看电视时激动,控制不住,外出走失1周找不到自己家,住在露天,公安人员收留送回家,吃饭用手抓着吃,记忆力下降,行为幼稚。既往高血压7年,脑梗死后10个月,神经系检查:BP225/110mmHg,说话口齿不清,右
监测站对某河段监测结果表明,水中铬超过卫生标准若干倍,在该河段上游有若干工厂,最有可能的污染源是
A.解表药B.活血化瘀药C.利水渗湿药D.清热药E.补虚药具有增强免疫功能、延缓衰老作用的中药是()。
患者,男,53岁。诊断为“大量心包积液”治疗给予安置心包引流管,对该患者的护理措施,错误的是
体征是指患者主观感受到的明显不适或痛苦。()
脚手架检查验收应按照相应规范要求进行,凡不符合规定的应立即进行整改,对检查结果及整改情况,应按实测数据进行记录,并由( )签字。
每逢“3.15”消费者节日,都能解决许多平时解决不了的问题,对此,你怎么看?
莎士比亚的“四大悲剧”是指《哈姆雷特》、《奥赛罗》、《李尔王》和______。
Rumorhasitthatmorethan20booksoncreationism/evolutionareinthepublisher’spipelines.Afewhavealreadyappeared.【F1】
ConservationistsonTuesdayappealedtocountriestourgentlyaddressnewthreatstowhales,dolphinsandothercetaceans(鲸类动物)a
最新回复
(
0
)