A system or service that is operative is working or having an effect.

An operative is a worker, especially one who does work with their hands.

An operative is someone who works for a government agency such as the intelligence service.

If you describe a word as the operative word, you want to draw attention to it because you think it is important or exactly true in a particular situation.