How to choose a protection diode (power)

So the diode will anyway dissipate some power while MCU is in sleep? Is this should be considered at all?