Microsoft
70-448 · Question #3
You plan to use SQL Server 2008 Integration Services (SSIS) on a SQL Server 2008 failover cluster. You have a complex package that takes a long time to run. You need to ensure that if the package…
The correct answer is C. Implement checkpoints within your package. See the full explanation below for the reasoning.
Question
You plan to use SQL Server 2008 Integration Services (SSIS) on a SQL Server 2008 failover cluster. You have a complex package that takes a long time to run. You need to ensure that if the package executes during a failover, the package can be resumed at the point of failure. What should you do?
Options
- ACluster the SSIS service.
- BCluster the SSIS service.
- CImplement checkpoints within your package.
- DImplement transactions within your package.
How the community answered
(20 responses)- B5% (1)
- C85% (17)
- D10% (2)
Community Discussion
No community discussion yet for this question.