Enables the transfer of a solute or solutes from one side of a membrane to the other according to the reaction: ATP + H2O + molybdate(out) = ADP + phosphate + molybdate(in).
molybdate transporting ATPase activity