Who is responsible for administrative supervision of database activities, including security, standards, backup strategy, and performance policies?

Difficulty: Easy

Correct Answer: Database administrator

Explanation:


Introduction / Context:
In any organization using databases, roles must be clearly defined. The individual accountable for policy enforcement, security, availability, standards, and data lifecycle is crucial to reliability and compliance. This question identifies that role.


Given Data / Assumptions:

  • The scope includes administrative supervision of database activities.
  • Tasks cover security, standards, backup/recovery, capacity planning, and performance.
  • Titles such as “DP Manager” are generic and may oversee broader IT, not specific database administration.


Concept / Approach:
The Database Administrator (DBA) owns operational governance of the DBMS: creating and managing instances, users, roles, backups, restores, replication, high availability, patching, and performance tuning. While IT managers may set department strategy, the DBA executes database-specific administration and enforces data policies.


Step-by-Step Solution:
Confirm the question’s scope: database-specific supervision.Map responsibilities to the standard DBA role.Choose “Database administrator.”


Verification / Alternative check:
Job descriptions and ITIL/COBIT practices place backup/restore, security administration, change control, and performance monitoring under the DBA’s responsibility, often in collaboration with system and storage teams.


Why Other Options Are Wrong:

  • DP Manager / DP administration / DB Manager: Vague titles; may oversee teams, but the specific administrative supervision of databases is the DBA’s role.
  • None of the above: Incorrect because DBA is correct and standard.


Common Pitfalls:
Assuming system administrators or developers will cover DBA duties informally; without a defined DBA, backup, security, and performance frequently degrade.


Final Answer:
Database administrator

Discussion & Comments

No comments yet. Be the first to comment!
Join Discussion