Quiz 70-450

Quiz 70-450, PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008

What should you do?

You need to ensure that if the Finance department does not approve the batch process, the batch operation can be rolled back in minimum possible time

You need to ensure that the following business requirements are met: The backup strategy supports point-in-time recovery for failure at any time of day

You need to restore the database to its state at the start of the batch process in the least possible time

You need to ensure that the data is available as quickly as possible with minimal effect on users

Which step should you choose?

Which backup option should you use?

Which three tasks should you include?

Which two tasks should you include in your design?

You need to correlate the operating system performance data with the actual query execution trace by using minimum administrative effort