You are a professional level SQL Sever 2008 Database Administrator in an international
corporation named Wiikigo. You are experienced in managing databases in an
enterprise-level organization, optimizing and sustaining the database life cycle. In the
company, your job is to implement solutions on security, troubleshooting, deployment and
optimization. A SQL Server 2008 infrastructure is managed by you. A corporate backup and
recovery strategy that has to be validated is designed. You are required to make sure that
any single database can be restored successfully from a severe failure, and during the
restoration, a backup data center should not be required in a different location. Which three
actions should be contained by your solution? (Choose more than one)
A.
All backup media offsite should be stored.
B.
One list of all Windows logins and passwords should be sustained.
C.
SQL login accounts and credentials should be scripted.
D.
The administrative processes and application access requirements should be
documented.
E.
All SQL Server instances should be installed on a failover cluster.
Explanation: