Only if they already know the concept to be able to ask about it. Otherwise, I would expect the LLM to suggest increasing the number of database connections, which punts the problem without actually fixing it. Maybe if it is being really clever, it will suggest they use a HA database and then completely fail to show them how to do it.
A LLM is basically a digital parrot. It has no intuition for what makes solutions good or bad, but it will happily parrot things that seem relevant, even when faced with evidence that they are not. It is enough to pass a number of undergraduate programming exams (especially since graders often give partial credit), but it is not enough to solve real world problems.
Mid engineers will disappear, but people who know what they are doing - in a few years will be kidnapped to cleanup LLM generated mess.