Microsoft-PRO Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005 Set 4

You need to select a high-availability solution for the CRM application. Which technology should you use?

You need to ensure that the regional delivery companies can access the tracking data. What should you do?

You need to modify the recovery plan for the CRM database to fulfill the companys business requirements. What should you do?

You need to design a stored procedure to import the registry information from AppServer1. You want to accomplish this goal without allowing the execution of unmanaged code. What should you do?

You need to select a high-availability solution for the CRM application. Which technology should you use?

You need to ensure that only the necessary protocols are enabled for the servers in the companys perimeter network. Which action or actions should you perform? (Choose all that apply.)

You need to design a method for improving performance for the reports that are run against the Orders database. What should you do?

You need to improve the speed of backups on SQL1. Management has approved the purchase of additional hard disks for this server. What should you do?

You need to enable more frequent backups of only the volatile data that is stored in the Doclib database. What should you do?

You need to implement an auditing strategy that will fulfill the companys business requirements. What should you do?