Can a metal roof leak from rain exposure? Is it water proof?

Yes, our metal roofs are completely water proof. Although very unlikely, if there is slight opening between metal tiles, the underlayment membrane stops any moisture from reaching your house.