Microsoft
70-448 · Question #2
70-448 Question #2: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #2. The question stem and answer options stay visible for context.
Question
You develop a package by using SQL Server 2008 Integration Services (SSIS). You use a local instance of SSIS to develop and test the package. The package uses an XML configuration file that contains a connection string. The connection string includes a user name and a password to connect to the source data. You deploy the package to the production server. You discover that validation errors occur when the package is being executed. You need to ensure that the package executes successfully in the production environment. What should you do?
Options
- AConfigure the package to use the DontSaveSensitive package protection level.
- BConfigure the package to use the EncryptSensitiveWithPassword package protection level.
- CConfigure the package to use the EncryptAllWithUserKey package protection level.
- DRemove the user name and the password from the connection string before you deploy the package.
Unlock 70-448 to see the answer
You've previewed enough free 70-448 questions. Unlock 70-448 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.