Microsoft
70-448 · Question #137
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…
The correct answer is C. Before restarting the package whenever a failover happening you should run checkpoints in your package. See the full explanation below for the reasoning.
Question
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?
Options
- ABefore restarting the package whenever a failover happening you should run store procedure in
- BYou should increase the SSIS service to the SQL Server cluster resource group.
- CBefore restarting the package whenever a failover happening you should run checkpoints in your package.
- DBefore restarting the package whenever a failover happens you should run transactions in your package.
How the community answered
(28 responses)- A7% (2)
- B4% (1)
- C71% (20)
- D18% (5)
Community Discussion
No community discussion yet for this question.