In theory the impressed current (Powered one) should last a lot longer.
BUT Given how long a standard magnesium rod can last (3 to 5 years or so), I would hesitate to install a powered one. If the power supply dies or gets zapped, it won't protect your tank.
The standard magnesium rods are pretty fool proof as long as you've got your water heater electrically isolated from any other piping and you replace the anode rod on a regular basis (last one I did was 5 years and it was toast, so next time I'm getting it at 3 years).
I had a plumber in my house recently who saw I had a spare anode rod hanging next to my water heater and a replacement schedule sharpied in on the tank and he said he'd never seen anyone else do that in his entire career. Sure would cut down on water heater replacements if everyone did it.