All cars suffer parasitic battery drain to some extent but if a healthy battery is drained enough not to start the car after two weeks there’s a fault. It’s easy enough to track down the fault too by monitoring the current draw with a cheap multimeter and pulling fuses until it stops. It’s often something as simple as bad boot light switch.
It can be prevented by disconnecting the negative battery terminal and locking the car with the key. I have to do this with my stepsons car which he leaves with us when he’s away for months working in the Middle East. (I could also prevent it by hooking up a trickle charger, but that’s more difficult given where the car is parked).