Microsoft
70-448 · Question #55
70-448 Question #55: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #55. 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) by using SQL Server 2008. Now you are employed in a company named NaproStar which uses SQL Server 2008. You work as the technical support. According to the requirement of the company CIO, you are using SQL Server 2008 Integration Services (SSIS) to create packages. The package connects to a third-party database server by using an OLE DB connection manager. Integrated Windows authentication is not supported by the database. A configuration file is created to configure the connection manager. The configuration file is added to the package after it is created. An error message pops up when the package executes. The error message says that the login step fails. Now you must solve this problem. So what should you do to successfully execute the package?
Options
- AIn order to achieve this goal, you should use an indirect XML configuration
- BIn order to achieve this goal, you should edit the XML configuration file
- CIn order to achieve this goal, you should use a Microsoft ADO.NET connection manager while not
- DIn order to achieve this goal, you should run the package on the same server as the third-party
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.