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

You are creating a management plan for the proseware_biz database. You need to specify the action that must be taken before manually inserting data through a bulk load process. Your plan must fulfill the availability and recoverability business requirements, and it also must require minimal administrative effort. Which action should you specify?

You need to set up the Bid_Archive database. What should you do?

You need to design the consolidation plan for SQL1, SQL2, and SQL3. You need to identify the appropriate combination of SQL Server instances and SQL Server 2005 computers that are needed to fulfill the companys consolidation plans and security requirements. Which combination should you use?

You need to define the data type and the table options for a new column named AnnualReview in the HR database. Which two options should you select? (Each correct answer presents part of the solution. Choose two.)

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 define the steps that are needed to implement the companys object creation and modification policies on SQL Server 2005. You want to achieve this goal by using the minimum amount of administrative effort. Which three actions should you perform? (Each correct answer presents part of the solution. Choose three.)

You need to develop a solution to recover deleted reservations on SQL2. What should you do?

You need to configure Active Directory to implement the new password policy for the HR department. What should you do?

You are creating a backup plan for the TravelOnline and Storefront databases. You need to ensure that the plan fulfills the companys recoverability and performance requirements. What should you do?

You want to consolidate some of the databases onto existing SQL Server computers until additional hardware can be purchased. You need to identify which of the servers, in its current configuration, can support additional databases. You need to ensure that your solution fulfills the companys security requirements while allowing for future database growth requirements. Which server and database combination can be used?