nerdexam
Microsoft

70-450 · Question #75

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…

The correct answer is 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. There isn't enough information here to make any specific recommendations. It's just a best practices question. One of the dumps suggests the answer is ADE, 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…

Design an optimized high availability and disaster recovery solution

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.

How the community answered

(63 responses)
  • A
    14% (9)
  • B
    8% (5)
  • C
    78% (49)

Explanation

There isn't enough information here to make any specific recommendations. It's just a best practices question. One of the dumps suggests the answer is ADE, 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

#disaster recovery validation#offsite backup storage#SQL login scripting#recovery documentation

Community Discussion

No community discussion yet for this question.

Full 70-450 Practice