70-450 · Question #38
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…
The correct answer is C. is the equivalent of "Rely on server storage", which allows SQL server to handle the security. There are several options for package protection.
Question
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?
Options
- Aand B) will cause the package to fail, and D) is just a terrible idea.
- BNo sensitive data should be saved together with the packages, and then the packages
- Cis the equivalent of "Rely on server storage", which allows SQL server to handle the security.
- DA common password should be set to make a highest level of security for all information in
How the community answered
(30 responses)- A10% (3)
- B3% (1)
- C83% (25)
- D3% (1)
Explanation
There are several options for package protection.
Topics
Community Discussion
No community discussion yet for this question.