Traditional Data Administrator (DA) — Which Role Is Theirs? Which responsibility is classically aligned with a data administrator (DA), as opposed to a database administrator (DBA)?
-
ATune database performance
-
BEstablish backup and recovery procedures
-
CResolve data ownership issues
-
DProtect the security of the database.
-
EDesign storage layouts and indexing strategies
Answer
Correct Answer: Resolve data ownership issues
Explanation
Introduction / Context:Organizations differentiate between enterprise data governance (DA) and technical database operations (DBA). Distinguishing these roles is critical for proper accountability and smoother data initiatives.
Given Data / Assumptions:
- DAs focus on governance, policies, data quality, and stewardship.
- DBAs focus on technical operation, performance, and recoverability.
- We must pick a responsibility aligned with DA.
Concept / Approach:Resolving data ownership issues—who “owns” definitions, stewards quality, and approves changes—is a governance matter, hence DA territory. DBAs implement technical controls and ensure databases perform, are secured, and can be recovered. While DA and DBA collaborate, their core charters differ.
Step-by-Step Solution:Identify governance-centric options among the choices.Map ownership and stewardship to DA, not DBA.Exclude performance, backup/recovery, and physical security as DBA duties.Select “Resolve data ownership issues.”
Verification / Alternative check:Typical data governance frameworks (for example, DAMA-DMBoK) assign stewardship and ownership clarification to DA/Chief Data Office roles.
Why Other Options Are Wrong:
- Tuning, backup/recovery, and database security are core DBA responsibilities.
- Storage/index design is physical database design (DBA).
Common Pitfalls:Assuming security is purely governance; DBAs implement technical security even if DA sets policy.
Final Answer:Resolve data ownership issues