PrepAway - Latest Free Exam Questions & Answers

Which is the correct answer to make sure that the package could be restored if the package runs during a failo

You are creating a SQL Server 2008 Integration Services (SSIS) package for Company.com.

You decide to utilize SQL Server 2008 Integration Services (SSIS) on a SQL Server 2008 failover cluster.
You own a complex package which costs too much time .
You should make sure that the package could be restored if the package runs during a failover.

Which is the correct answer?

PrepAway - Latest Free Exam Questions & Answers

A.
Before restarting the package whenever a failover happening you should run store procedure in your package.

B.
You should increase the SSIS service to the SQL Server cluster resource group.

C.
Before restarting the package whenever a failover happening you should run checkpoints in your package.

D.
Before restarting the package whenever a failover happens you should run transactions in your package.


Leave a Reply