To prevent operational disruption when making changes to a database system, what approach should an organization adopt?

• A. Implement a well-planned upgrade process
• B. Acquire change approval
• C. Load balancing
• D. Performance tuning

Answer: (A)

Implementing a well-planned upgrade process is essential for preventing operational disruption when making changes to a database system. A structured upgrade process involves several key steps, including risk assessment, testing, and scheduling, which help ensure that changes are made smoothly and with minimal impact on the existing operations.

By following a well-defined upgrade strategy, organizations can identify potential issues before they affect the production environment, implement necessary changes systematically, and roll back to a previous state if complications arise. This approach diminishes the likelihood of outages, data loss, or performance degradation that could occur with poorly managed changes.

Additionally, while acquiring change approval is important to maintain oversight and governance, it alone does not address the technical aspects of implementation, such as planning and execution. Approaches like load balancing and performance tuning pertain to optimizing system capacity and efficiency rather than directly facilitating safe and effective changes during upgrades. Therefore, a well-planned upgrade process stands out as the most comprehensive way to minimize disruption.