PrepAway - Latest Free Exam Questions & Answers

Which of the following protection levels should you use?

You work as an Administrator for ABC.com. The company has a SQL Server 2008 computer. You
are creating a SQL Server 2008 Integration Services (SSIS) package. The package contains some
sensitive data that needs protection. In order to protect the package, you decide to encrypt the
entire package including the sensitive data. You provide a password to accomplish this. Which of
the following protection levels should you use?

PrepAway - Latest Free Exam Questions & Answers

A.
EncryptAllWithUserKey

B.
EncryptSensitiveWithUserKey

C.
EncryptAllWithPassword

D.
EncryptSensitiveWithPassword


Leave a Reply