Put it at the end of a build-up, after the hopeful setup has played out, so it acts as the final answer to the question on screen. For extra tension, open with the Dun Dun Dun sound, then let this clip close the scene, and add the Vine Boom sound only if the outcome turns out badly.