70-448 · Question #55
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…
The correct answer is B. In order to achieve this goal, you should edit the XML configuration file. See the full explanation below for the reasoning.
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
How the community answered
(22 responses)- A5% (1)
- B82% (18)
- C5% (1)
- D9% (2)
Community Discussion
No community discussion yet for this question.