You are a professional level SQL Sever 2008 Database Administrator. New SQL Server
2008 Integration Services (SSIS) packages will be deployed, and the packages are created
by the SQL Server Import and Export Wizard. The packages will utilize stored user names
and passwords to connect to external data sources. Since you are the technical support of
your company, you are required to confirm that unauthorized users can not get access to
the user names and passwords. Which action will you perform?
A.
The SQL Server 2008 server should be utilized to store the packages, and administrate
the security in the SQL Server 2008 server.
B.
A common password should be set to make a highest level of security for all information
in the package when each package is saved.
C.
No sensitive data should be saved together with the packages, and then the packages
should be saved in the SQL Server 2008 server.
D.
No other data should be saved together with the packages, and then files should be
saved to the most secure directory.