- Imagine you are a DBA for a mid-sized company with twelve (12) SQL database servers. Suppose you were asked to implement the simplest and most cost-effective form of high-availability method. Recommend a solution for the provided situation and provide a rationale for your response.
- As a DBA, you need to account for all of the server downtime and react to the unforeseen occurrences. Imagine you are responsible for maintaining the availability of twelve (12) database servers. Review the Microsoft Developer Network articles titled, â€œDatabase Mirroring (SQL Server)â€ located at http://msdn.microsoft.com/en-us/library/ms189852.aspx, and â€œAlwaysOn Availability Groups (SQL Server)â€ located at http://msdn.microsoft.com/en-us/library/hh510230.aspx. Then, recommend the service that you would most likely use, and provide a rationale for your response.
“Replication and SSIS”
- Imagine you are a DBA for a Regional Bank located in the South East. Your job is to ensure replication takes place between the branch offices and the main headquarters. Consider the use of snapshot, transactional, and merge replications, and provide an example of when each of these services could be used in the banking industry. Identify the service you would use and the reasons for your selection.
- Suppose your company has decided to use the MS SQL Server Integration Services. Using the Internet, research this service and determine the service that you would use. Provide a rationale for your response.
“Course Conclusion “
- You have just completed ten (10) weeks of a database administration course. Imagine you have been asked to create a one-day training course that highlights the important elements of what you have just learned within the past ten (10) weeks.
- Create a hierarchy of no more or no less than five (5) of the most important topics that you believe that a one-day course entitled â€œAdministering Microsoft SQL Server 2012: The Essentials Presented in One Dayâ€ should address. Provide a detailed rationale for each of the five (5) topics.