How do I decide whether the subject of an Advanced Certificate Program is relevant enough for my career?

Start with the skill the target role actually requires. If the certificate develops that capability and gives you a way to demonstrate it, the learning has a clearer professional purpose than simply adding another credential.