Skip to content
- Identify whether the growth of the database or the business growth is going to influence your design. Justify your response.
- Outline any potential concerns of upgrading the SQL Server to a 2012 platform.
- Recommend a solution for the login accounts, and explain how consultants can adhere to the current password policy at the database and object level.
- Recommend two (2) ways to address the issue of high availability. Outline your recommendations.
- Design a replication topology to copy data between the branch offices to the headquarters’ database, outlining any latency, autonomy, and consistency issues.
- Using Visio or an open source alternative such as Dia, outline the proposed changes that will accommodate the plan for replication. Note: The graphically depicted solution is not included in the required page length.
- Use at least three (3) quality resources in this assignment not including the textbook. Note: Wikipedia and similar Websites do not qualify as quality resources.
