get the app get the app       get the app       get the app
You work as a database administrator at Abc.com. You are currently creating a SQL Server 2008 Integration Services (SSIS) package for Abc.com. You decide to make use of the SQL Server 2008 Integration Services (SSIS) on a SQL Server 2008 failover cluster. You create a complex package which takes a considerable amount of processing time. You need to ensure that package can be restored if it runs while a failover is occurring. What should you do?

1)You should consider running a restore procedure in the package prior to restarting the package when a failover occurs.

2)You should consider adding the SSIS service to the SQL Server cluster resource group.

3)You should consider running checkpoints in the package prior to restarting the package when a failover occurs.

4)You should consider running the dtutil tools in the package prior to restarting the package when a failover occurs.


  • : 193
  • : 1
    Previous Next

    You should consider running checkpoints in the package prior to restarting the package when a failover occurs.

    Suggest other answer
    Login to Discuss/suggest the answer...

  • Exam: 70-448 MS SQL Server 2008, Business Intelligence





    Recommended Learning for you

    Close(X)
    Subscribe here for free mock test on IAS PCS SSC and other competitive exam. Signup here to get SSC CGL Solution and main exam study material