PrepAway - Latest Free Exam Questions & Answers

You need to ensure that if the package executes during a failover, the package can be resumed at the point of

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?

PrepAway - Latest Free Exam Questions & Answers

A.
Cluster the SSIS service. Add the SSIS service to its own cluster resource group.

B.
Cluster the SSIS service. Add the SSIS service to the SQL Server cluster resource group.

C.
Implement checkpoints within your package. Restart the package whenever a failover
occurs.

D.
Implement transactions within your package. Restart the package whenever a failover
occurs.


Leave a Reply