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 SQL Server instances should be installed on a failover cluster.
B.
One list of all Windows logins and passwords should be sustained.
C.
All backup media offsite should be stored.
D.
SQL login accounts and credentials should be scripted.
E.
The administrative processes and application access requirements should be documented.