Microsoft
70-450 · Question #75
70-450 Question #75: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #75. The question stem and answer options stay visible for context.
Question
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)
Options
- AAll SQL Server instances should be installed on a failover cluster.
- BOne list of all Windows logins and passwords should be sustained.
- CAll backup media offsite should be stored.
- DSQL login accounts and credentials should be scripted.
- EThe administrative processes and application access requirements should be documented.
Unlock 70-450 to see the answer
You've previewed enough free 70-450 questions. Unlock 70-450 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.