首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
24
问题
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
微软认证
相关试题推荐
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
BarackObamaspentmuchtimeonthecampaigntrailproposingadramaticvisiontochangenotonlytheUnitedStatesforthebett
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
MireilleGuiliano,achampagnecompanyexecutive,capturedtheattentionoffrustrateddieterswithherjoyoflifeinthe2005
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
随机试题
急性胰腺炎患者应禁用的药物为
干酪型结核性腹膜炎的主要并发症为
A、卧床休息B、抗生素C、立即刮宫D、观察无特殊处理E、先用雌激素后做刮宫术停经45天,尿妊娠试验(+),伴少量阴道出血及轻微下腹部不适,内诊子宫6周大小()
患者赖某,男,48岁,个体户。因服大量的安眠药自杀而被家属送至某医院急诊室。家属告知急诊医生,患者有精神分裂症,一直服药治疗,过去也有服药后睡一天才醒的情况,此次睡一天一夜未醒,才发现服用大量的安眠药自杀;经急诊室两天两夜的抢救,患者仍处于昏迷状态。于是,
当石质坚硬完整且岩石抗压强度大于30MPa,并确认不影响结构稳定和强度时,允许岩石个别凸出部分在1m2内不大于()。
某企业设有供电和供水两个辅助生产车间,为基本生产车间和行政管理等部门提供服务,根据“辅助生产成本”汇总的资料,供电、供水车间本月发生费用分别是17400元和8500元。两个辅助生产车间供应产品和劳务数量如下表所示:要求:采用顺序分配法进行辅助生产费用的
科学家在海水提铀方面不断取得进步,正快速朝着将海洋变成铀库的道路前进。下列关于铀的说法正确的是()。
MPC(MultimediaPC)与PC的主要区别是增加了(10)。
A—mouseI—draganddropB—centralprocessingunitJ—electroniccommerceC—CADK—floppydiskD—dataprocessingL—homepageE—desk
A、Theywillvarywiththesizeofvehicles.B、Theywillbediscountabletoregularcustomers.C、Theywillbelowerthanconventi
最新回复
(
0
)