Microsoft
70-450 · Question #38
70-450 Question #38: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #38. The question stem and answer options stay visible for context.
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
Unlock 70-450 to see the answer
You've previewed enough free 70-450 questions. Unlock 70-450 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.