PrepAway - Latest Free Exam Questions & Answers

Which action will you perform?

You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. You are experienced in managing databases in an enterprise-level organization,optimizing
and sustaining the database life cycle.
In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization.
A SQL Server 2008 instance of your company is managed by you.
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?

PrepAway - Latest Free Exam Questions & Answers

A.
No other data should be saved together with the packages, and then files should be saved to the most secure directory.

B.
No sensitive data should be saved together with the packages, and then the packages should be saved in the SQL Server 2008 server.

C.
The SQL Server 2008 server should be utilized to store the packages, and administrate the security in the SQL Server 2008 server.

D.
A common password should be set to make a highest level of security for all information in the package when each package is saved.


Leave a Reply