The track is "I Need a Hero" by Bonnie Tyler. This iconic 1984 power ballad plays during the grand entrance scene when Fiona and Shrek arrive at the Far Far Away castle in Shrek 2, transformed into human royalty by the Fairy Godmother's potion.
The Shrek 2 soundtrack (2004) masterfully blended contemporary covers with original score. Other notable needle-drops include "Accidentally in Love" (Counting Crows), "Holding Out for a Hero" (Jennifer Saunders as Fairy Godmother), and "Livin' la Vida Loca" (Eddie Murphy as Donkey). "I Need a Hero" remains one of the franchise's most memorable musical moments.