70-450 · Question #3
You administer a SQL Server 2008 infrastructure . You design a corporate backup and recovery strategy that has to be validated. You need to ensure the successful recovery of any single database from…
The correct answer is A. Store all backup media offsite. B. Script SQL login accounts and credentials. E. Document the administrative processes and application access requirements. There isn't enough information here to make any specific recommendations. It's just a best practices question. Some dumps suggests other answers, but I don't think a cluster would help in this scenario. It's hard to tell because the type of failure isn't explained. Since a…
Question
You administer a SQL Server 2008 infrastructure . You design a corporate backup and recovery strategy that has to be validated. You need to ensure the successful recovery of any single database from a catastrophic failure without requiring a backup data center in a different location. Which three tasks should you include? (Each correct answer presents part of the solution. Choose three.)
Options
- AStore all backup media offsite.
- BScript SQL login accounts and credentials.
- CInstall all SQL Server instances on a failover cluster.
- DMaintain one list of all Windows logins and passwords.
- EDocument the administrative processes and application access requirements.
How the community answered
(17 responses)- A76% (13)
- C12% (2)
- D12% (2)
Explanation
There isn't enough information here to make any specific recommendations. It's just a best practices question. Some dumps suggests other answers, but I don't think a cluster would help in this scenario. It's hard to tell because the type of failure isn't explained. Since a restore operation is needed, it seems like a disk failure.
Topics
Community Discussion
No community discussion yet for this question.