You administer a SQL Server 2008 instance. You plan to deploy new SQL Server 2008
Integration Services (SSIS) packages that are created by the SQL Server Import and Export
Wizard. The packages will connect to external data sources by using stored user names
and passwords. You need to ensure that the user names and passwords are protected from
access by unauthorized users. What should you do?
A.
Use the SQL Server 2008 server to store the packages, and manage the security in the
SQL Server 2008 server.
B.
Set a common password to make all information in the package as secure as possible
when each package is saved.
C.
Ensure that no sensitive data is saved along with the packages, and save the packages
in the SQL Server 2008 server.
D.
Ensure that no data is saved along with the packages, and save the files to the most
secure directory.