Most of the top brands are coated with high-quality vinyl that effectively keeps the water out. The Velcro and the overlapping zippers also help prevent leaking.
However, soft tops only keep out the water from light showers. Continuous exposure to heavy rain will wear down the vinyl, and your top will eventually leak.