试题详情
多项选择题 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?()

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. 

  • A,D,E
  • 关注下方微信公众号,在线模考后查看

热门试题