Your main transactional database runs a version that goes out of vendor support in four months. Upgrading needs an estimated eight engineer-weeks and a maintenance window the business does not want to give. The CTO asks you to recommend whether to accept the risk for another twelve months. Talk me through how you would decide.
Show the full answer Hide the answer
What the interviewer is testing
Whether you can turn "unsupported is bad" into a decision someone can act on and be accountable for. A candidate who says only "we must upgrade" has not engaged with the constraint; one who says "accept it" without conditions has not engaged with the risk.
The clarifying questions that change the answer
- What does end of support actually remove? Usually: security patches, vendor assistance during an incident, and certification of the platform under a compliance regime. Those three have very different consequences, and only the first two are technical.
- Is there an extended support option and what does it cost? Vendors commonly sell it. A quantified alternative changes the conversation from a risk debate into a purchase decision.
- What is the exposure? Internet-reachable or not, what data it holds, what the last two years of security advisories for this version looked like.
- What breaks the upgrade? Eight weeks is an estimate. Ask what it depends on — an extension, a driver, a query that changed plan — because the estimate's variance matters more than its mean.
- Does any contract or certification require supported software? That is a hard constraint masquerading as a risk trade-off, and it settles the question immediately.
How I would frame the decision
Not with a 5×5 matrix producing "high". Express it as a loss exposure with an honest range: the probability of a critical unpatched vulnerability in a twelve-month window for this product, based on its advisory history, multiplied by a cost band for the incident it would cause. Compare that against the cost of eight engineer-weeks plus the business cost of the window.
If the numbers are close, the decision is not about numbers: it is about who carries the consequence and whether that person is in the room.
What a strong answer adds
- A time-boxed acceptance, never an open one. Twelve months with a named owner, a stated expiry and a review date, recorded where an auditor and a successor can find it.
- Compensating controls that reduce the exposure now, cheaply: restricting network reachability, tightening monitoring on that host, rehearsing the failover, confirming restores.
- Trigger conditions that void the acceptance: a critical advisory for this version, or a change that puts new regulated data on it. An acceptance without triggers is not a decision, it is a deferral.
- The upgrade being scheduled in the acceptance, not promised after it.
Common weak answers
- "Escalate to the CISO." It may be the right escalation, and it is not a recommendation. You were asked for one.
- "Run it unsupported, it is fine, plenty of people do." True and irrelevant: the question is who signs for it and what happens when an advisory lands.
- Quantifying to two decimal places. A false precision that invites argument about the model instead of the decision. A range with its assumptions stated is more persuasive and more honest.