Is cement board waterproof

Yes. That is why it's recommended to use instead of gypsum drywall in wet applications such as bathrooms/showers, etc.