nerdexam
CompTIA

SK0-004 · Question #181

A line-of-business software patch notification is received. The notification indicates that version 5.0 of the software has new features that the accounting department has been expecting. The update…

The correct answer is C. Develop a plan to build a test server. Before applying a major software update that requires OS and SQL upgrades, the first step is to build a test server to safely validate the changes without risking the production environment.

Server administration

Question

A line-of-business software patch notification is received. The notification indicates that version 5.0 of the software has new features that the accounting department has been expecting. The update requires a new version of the OS and new version of SQL on the server. Which of the following should the administrator perform FIRST?

Options

  • ASchedule downtime to update the OS and SQL on the server.
  • BDownload and test the new version.
  • CDevelop a plan to build a test server.
  • DRequest feedback from the accounting department.

How the community answered

(27 responses)
  • A
    7% (2)
  • B
    4% (1)
  • C
    81% (22)
  • D
    7% (2)

Why each option

Before applying a major software update that requires OS and SQL upgrades, the first step is to build a test server to safely validate the changes without risking the production environment.

ASchedule downtime to update the OS and SQL on the server.

Scheduling downtime before a test environment exists is premature because the scope, duration, and rollback plan for the maintenance window cannot be accurately determined until the update has been tested.

BDownload and test the new version.

Downloading and testing the new version without a dedicated test server would likely mean testing on the production system, which risks data corruption and unplanned outages.

CDevelop a plan to build a test server.Correct

A test server provides an isolated environment to validate the compatibility of the new application version with the required OS and SQL updates before touching production. This is the foundational first step because it de-risks the entire update process - without a test environment, subsequent steps like downloading or scheduling downtime could lead to an unrecoverable production outage.

DRequest feedback from the accounting department.

The accounting department has already indicated what features they expect; soliciting feedback again does not address the technical risk of applying a complex multi-component upgrade.

Concept tested: Test environment planning before major application upgrades

Source: https://learn.microsoft.com/en-us/azure/well-architected/operational-excellence/safe-deployments

Topics

#change management#patch management#test environment#dependency analysis

Community Discussion

No community discussion yet for this question.

Full SK0-004 Practice