Microsoft
70-448 · Question #148
70-448 Question #148: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #148. The question stem and answer options stay visible for context.
Question
You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server 2008. Now you are employed in a company which is named NaproStar and work as the technical support for the company which uses SQL Server 2008. To meet the business development, you use SQL Server 2008 to create a SQL Server 2008 Integration Services (SSIS) package. You have a Research server named SQL_RES01 and a Sales server named SQL_SAL01. SQL_RES01 is not connected to SQL_SAL01 in the network. Then you have the SSIS package configured on the SQL_SAL01 server, however, you get a failure of the configuration, which is because the SQL_RES01 server can not be connected by the package. In order to solve that problem, the package should be modified to refer to the SQL_SAL01 server when you execute the configuration. Which solution would be chosen to solve that problem?
Options
- AAfter selecting the Connection Manager check box, you should modify the connection string on the
- BUse the ServerStorage package protection level to modify the properties of the package.
- CAfter modifying the deployment manifest file in Microsoft Notepad, you should modify the properties
- DUse the DontSaveSensitive package protection level to modify the properties of the package.
- EAfter modifying the deployment manifest file in Microsoft Notepad, you should modify the connection
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.