Place it as the final beat of a setup, after the risky moment has been shown but before any outcome appears. For a failed attempt, let Womp Womp Fail Sound land first, then close with this clip. When the story does continue, open the next part with Giorno Giovanna Theme to signal the payoff.