Difficulty: Easy
Correct Answer: Correct
Explanation:
Introduction / Context:
This question probes whether you recognize the central role of Database Administration (DBA) in operational reliability. Technology problems are often blamed on software or hardware, but root-cause analyses frequently point to gaps in administration processes such as backups, security, change control, and performance tuning.
Given Data / Assumptions:
Concept / Approach:
DB reliability is a socio-technical outcome. Robust processes (regular, tested backups; well-defined recovery point/time objectives; patching; access control; index and query management) are decisive. Where these are weak or absent, even a strong DBMS can fail dramatically. Hence, the absence of a strong DBA function is a common—often the most common—cause of database failures.
Step-by-Step Solution:
Verification / Alternative check:
Review postmortems: many cite untested backups, missing monitoring, misconfigured replication, or uncontrolled schema changes—all domain of DBA governance.
Why Other Options Are Wrong:
Common Pitfalls:
Over-reliance on vendor defaults; assuming cloud-managed services eliminate DBA responsibilities; neglecting restore tests.
Final Answer:
Correct
Discussion & Comments