Exit 70-448 TS:MS SQL Server 2008.Business Intelligence Dev and Maintenan
Question 1 of 5
0% complete
Q1 Single choice

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?

  • 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.

Previous Next