Microsoft
70-448 · Question #342
You design a Business Intelligence (BI) solution by using SQL Server 2008. You develop SQL Server 2008 Integration Services (SSIS) projects. You plan to deploy the projects in the following manner…
The correct answer is B. Configure the child packages to log their events to a SQL Server log provider. See the full explanation below for the reasoning.
Question
You design a Business Intelligence (BI) solution by using SQL Server 2008. You develop SQL Server 2008 Integration Services (SSIS) projects. You plan to deploy the projects in the following manner:
A parent package on an instance that is named SSIS1. Three child packages individually on three instances that are named SSIS2, SSIS3, and SSIS4. You need to ensure that the parent package can discover the execution state of the child packages. What should you do?
Options
- AConfigure the parent package to log its events to a SQL Server log provider.
- BConfigure the child packages to log their events to a SQL Server log provider.
- CConfigure the parent package to log its events to a SQL Server Profiler log provider.
- DConfigure the child packages to log their events to a SQL Server Profiler log provider.
How the community answered
(55 responses)- A5% (3)
- B78% (43)
- C4% (2)
- D13% (7)
Community Discussion
No community discussion yet for this question.