You develop a package in SQL Server 2008 Integration Services (SSIS). You need to deploy the package so that it meets the following requirements: - Only authorized users can view and execute the package. - Users will NOT know the database credentials from within the package. - The package should NOT be stored in the MSDB database. What should you do?

A. Set the protection level to DontSaveSensitive.

B. Set the protection level to EncryptSensitiveWithPassword.

C. Set the protection level to ServerStorage.

Microsoft

70-448 · Question #219

You develop a package in SQL Server 2008 Integration Services (SSIS). You need to deploy the package so that it meets the following requirements: - Only authorized users can view and execute the…

The correct answer is D. Set the protection level to EncryptAIIWithUserKey. EncryptAllWithUserKey Encrypts the entire package by using keys based on the user profile. Only the same user using the same profile can load the package. * ProtectionLevel The protection level of the package. The values are DontSaveSensitive, EncryptSensitiveWithUserKey…

Implement an SSIS Solution

Question

You develop a package in SQL Server 2008 Integration Services (SSIS). You need to deploy the package so that it meets the following requirements:

Only authorized users can view and execute the package.
Users will NOT know the database credentials from within the package.
The package should NOT be stored in the MSDB database.

What should you do?

Options

ASet the protection level to DontSaveSensitive.
BSet the protection level to EncryptSensitiveWithPassword.
CSet the protection level to ServerStorage.
DSet the protection level to EncryptAIIWithUserKey.

How the community answered

(60 responses)

A
3% (2)
B
8% (5)
C
12% (7)
D
77% (46)

Explanation

EncryptAllWithUserKey Encrypts the entire package by using keys based on the user profile. Only the same user using the same profile can load the package. * ProtectionLevel The protection level of the package. The values are DontSaveSensitive, EncryptSensitiveWithUserKey, EncryptSensitiveWithPassword, EncryptAllWithPassword, and ServerStorage. The default value of this property is EncryptSensitiveWithUserKey. Not A: DontSaveSensitive Sensitive information is not saved in the package. The sensitive information is removed and replaced with blanks. Not C: ServerStorage Encrypts the package within a SQL Server msdb database. This option is supported only when a package is saved to SQL Server. It is not supported when a package is saved to the File System. The access control of who can decrypt the package is controlled by SQL Server database roles. Not D: EncryptSensitiveWithPassword Encrypts only sensitive information contained in the package by using a password. DPAPI is used for this encryption.

Topics

#package protection level#EncryptAllWithUserKey#package deployment#sensitive data security

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice