2. 计算机
  3. 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

admin2009-05-19  49
问题 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://www.kaotiyun.com/show/0uhZ777K
本试题收录于： 微软70228题库微软认证分类
0

微软70228

微软认证

相关试题推荐
随机试题
最新回复(0)