Microsoft
70-450 · Question #113
70-450 Question #113: Real Exam Question with Answer & Explanation
The correct answer is A. Use the SQL Server 2008 server to store the packages, and manage the security in the SQL. See the full explanation below for the reasoning.
Question
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?
Options
- AUse the SQL Server 2008 server to store the packages, and manage the security in the SQL
- BEnsure that no data is saved along with the packages, and save the files to the most secure
- CEnsure that no sensitive data is saved along with the packages, and save the packages in the
- DSet a common password to make all information in the package as secure as possible when
Community Discussion
No community discussion yet for this question.