Depends upon where you mean for flooding.
If you mean flooding from the display tank out to the floor, then simply have an emergency drain line, one that is NEVER used (underwater) and if your main drain gets clogged water will rise and the emergency will take over (and hopefully you notice the clog before the emergency clogs up

). Also having screens near (but not on) pipes will help keep critters out (snails are notorious), you don't want the screen actually on the pipe though because that's a sure fire way to make sure it clogs up.
If you mean in the case of a power outage. #1 thing you can do is to make sure your sump is properly sized. I often (and I've been guilty of this) the chamber that pumps water back into the tank is extremely small compared to the rest of the sump. So when you lose power you'll fill that one, up, and the other chambers are already full, and sploosh all over the floor. Also you can help yourself by making sure your baffles are not terribly high, leave some room. Test it all by yanking the power cord on your return pump and see if you'll flood (better to see it when you're actually home!).
Siphon breaks can work too, however make sure you drill them large enough compared with your pipe size, a pin hole siphon break... will not break a siphon. It needs to be able to suck in enough air such that the siphon breaks, and I often have seen them too small. Or they're clogged up (especially light can shine on the pipe). I find it easier to simply have my return pipe just below the water's surface, not so high that you cause bubbles to form, but high enough that pipe itself is a siphon break
Bottom line, multiple redunancies help a lot more than a single one. Having a siphon break/high pipe PLUS enough room in the sump incase either fails.