220-1102 Operational Procedures Practice Question
A change request to upgrade the operating system on a database server has been approved by the Change Advisory Board (CAB). During the scheduled maintenance window, the technician completes the upgrade successfully. However, after rebooting, a critical business application fails to connect to the database. A full backup of the server was taken before the change. According to change management best practices, what should the technician do NEXT?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Restore the server from the backup to return to the previous state.
The best practice in change management is to have a rollback plan. Since the change caused an unexpected negative impact (application outage), the technician should restore the server from the backup to return to the previous known-good state. This minimizes downtime and allows for a thorough investigation. Escalating (A) is appropriate after rollback, but the immediate priority is to restore service. Applying additional patches (C) could introduce further issues without a clear diagnosis. Rebooting again (D) is unlikely to resolve a compatibility issue.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Document the failure and escalate to the CAB for guidance on next steps.
Why it's wrong here
While documenting the failure and notifying the change advisory board is an important post-incident step, it does not address the active outage. A predefined rollback plan exists specifically for this situation, so waiting for CAB guidance needlessly lengthens downtime and risks violating the approved maintenance window. The immediate priority must be restoring service from the backup, then using the CAB for root-cause analysis afterward.
- ✓
Restore the server from the backup to return to the previous state.
Why this is correct
The full backup taken before the upgrade provides a known-good system state; restoring it reverts the operating system and installed components to the exact pre-change configuration. This is the standard rollback action because it returns the database server to the last known working condition, allowing the business application to reconnect while the compatibility problem is investigated. After restoration, validate database integrity and test connectivity before reopening access.
- ✗
Apply additional patches or configuration changes to the database server to fix the compatibility issue.
Why it's wrong here
Applying unapproved patches or tweaking configuration settings to fix a database-compatibility issue is dangerous because the root cause is not yet understood and may involve multiple components. Such ad-hoc changes violate change management policy, invalidate the tested rollback path, and can leave the database in an undocumented, unstable state. A controlled rollback to the backup is the safe first step, with any future fix going through a new change request.
- ✗
Reboot the server again to see if the application connection issue resolves itself.
Why it's wrong here
A reboot merely restarts the same upgraded operating system and does not change the installed OS version, drivers, or configuration. If the application connection failure stems from a compatibility mismatch introduced by the upgrade, a second reboot will reproduce the identical broken state rather than resolve it. This delay consumes valuable maintenance-window time and distracts from the correct rollback action.
Visual reference
Go deeper
Related to this question
Learn chapter
Standard Operating Procedures (SOPs)
Key term
Change management
Change management is the structured process of planning, approving, implementing, and reviewing changes to IT systems to minimize risk and disruption.
Key term
Operating system
An operating system (OS) is the core software that manages a computer's hardware and software resources, providing common services for computer programs.
About these practice questions
Courseiva writes every 220-1102 question from scratch — 925 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This 220-1102 practice question is part of Courseiva's free CompTIA certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the 220-1102 exam.