DBA Business Considerations - Exercise

Who owns each backup and recovery responsibility?

Objective: Distinguish the DBA's technical responsibilities from management's business responsibilities when planning and carrying out database backup and recovery.

Exercise Scoring

This exercise is unscored. After you submit your choices, the result page will show your answer, the expected owner, and an explanation for each responsibility.

Instructions

Select the role with primary responsibility for each item. Use each role as often as needed; this is not a one-to-one matching exercise.

A: Database Administrator (DBA), including the database operations team.
B: Management, including the relevant business owners.

For this exercise, distinguish responsibility for technical work from authority over business requirements, priorities, and funding. The two roles collaborate, and an organization may distribute tasks among several teams.

Choose an answer for all seven responsibilities, then select Submit Answers.

Match each responsibility to its primary owner
Responsibility	Your choice
1. Monitor database usage, performance, and capacity.
2. Identify and prioritize new business requirements for database-backed services.
3. Quantify the business cost and impact of downtime and data loss.
4. Perform database restore and recovery using the agreed recovery procedure.
5. Evaluate the proposed backup and recovery strategy against business needs, approve it, and authorize funding.
6. Design, implement, maintain, and test the technical backup and recovery plan.
7. Provide database recovery-time estimates based on restore and recovery tests.