Place it at the exact moment a mistake is revealed, before any reaction or commentary, so the warning lands first. Follow it with the Classic Error Sound Effect for a bigger blunder, or the Bell Ding Sound Effect when the error is small and playful, and save the Dramatic Dun Dun Dun Sound Effect for the reveal that follows.