MCQOPTIONS
Saved Bookmarks
| 1. |
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? |
| A. | You should consider running a restore procedure in the package prior to restarting the package when a failover occurs. |
| B. | You should consider adding the SSIS service to the SQL Server cluster resource group. |
| C. | You should consider running checkpoints in the package prior to restarting the package when a failover occurs. |
| D. | You should consider running the dtutil tools in the package prior to restarting the package when a failover occurs. |
| Answer» D. You should consider running the dtutil tools in the package prior to restarting the package when a failover occurs. | |