You work as a database administrator at ABC.com. You are assigned to manage a server named
ABC-DB01. Your duties include managing a SQL Server 2008 Integration Services (SSIS)
instance.
The SQL instance was tested in a local development environment. You receive an instruction from
the CIO to deploy the instance to ABC-DB01. The CIO informs you that the level of security must
be configured for users when they run the package.
Which of the following actions should you take?
A.
The EncryptPartWithUserKey option should be used.
B.
The EncryptAllWithUserKey option should be used.
C.
The connection string should be used.
D.
The ServerStorage option should be used.