Microsoft
70-448 · Question #150
70-448 Question #150: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #150. The question stem and answer options stay visible for context.
Question
You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server 2008. Now you are employed in a company which is named NaproStar and work as a developer of a SQL Server 2008 Integration Services (SSIS) for the company. To meet the business requirements, SSIS should be used on a SQL Server 2008 failover cluster. There is a complex package on your server and it needs a long time to start it. Now your manager asks you to make sure that the package can be resumed when it fails to execute the failover. What action should you perform?
Options
- AFirst you should have checkpoints implemented within your package, and then restart the package
- BFirst you should have transactions implemented within your package, and then restart the package
- CFirst you should cluster the SSIS service, and then restart the package whenever a failover occurs
- DFirst you should cluster the SSIS service, and then have the SSIS service added to its own cluster
- EFirst you should cluster the SSIS service, and then have the SSIS service added to the SQL Server
Unlock 70-448 to see the answer
You've previewed enough free 70-448 questions. Unlock 70-448 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.