YOU HAVE INSTALLED SQL SERVER 2008 IN AN ACTIVE PASSIVE ENVIRONMEN...

15. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P52 PPTX
THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P52 PPTX
15. You have installed SQL Server 2008 in an Active Passive environment running on the servers SQL01A and SQL01B. You have several SSIS packages within your database environment. You have installed SQL Server as the default instance using the default configuration on your cluster using the name SQL01V01 as the clustered resource name. When your SQL Server’s Resource Group is running on SQL01B the SSIS packages work without error. When your SQL Server’s Resource Group is running on SQL01A the SSIS packages fail to start. All the SSIS packages are run from SQL Agent Jobs. How should you correct this problem?A. Fail the SQL Server back to SQL01B and always run the SQL Server on that node.B. Reconfigure the SQL Agent Jobs that run the SSIS jobs to use SQL01B as the SSIS repository instead of SQL01V01.C. Install the SQL Server Integration Services service on the SQL01A and apply the same patches and hotfixes that are in use by the SQL Server service.D. Configure another SQL Server to be the SSIS repository instead of SQL01V01.